Hi,
I'm working on a new project for a friend of mine.
He's trying to track his "Support Activities."
First I inserted this for counting cells:
=B2*(COUNT(C2:I2)+COUNTIF(C2:I2,"x")+COUNTIF(C2:I2,"y"))
Now there are sixty of these rows. B2 to B62
That works fine. However the problem is the
Hi Karthik!
Thanks for the reply!
I liked the use of the LEN & AND statements, but your formula seemed longer
than mine.
So I looked at yours again and realized I could ALSO use:
'=IF(Len(I2)<=5,CONCATENATE("AB",TEXT(I2,"0")),I2)
Now granted, it does allow for accidental numbers, like
Hi, I've got an odd problem.
I have a database of some 15000 numbers.
10,000 of them (roughly), go from 1 to 10,000.
Another 5,000 go from 1,000,000 to 2,000,000.
However, the numbers SHOULD AB1 to AB1.
I need to be able to type the root number in and have Excel decide what it
needs:
Okay, after a bit of research, I've gotten a sort of formula:
=IF((A1)>10,(A1),(CONCATENATE("AB",(TEXT(A1,"0")
This actually does what I wanted. However, I'd still like to have the final
number be just a literal number, not a formula.
Assuming A1 is the original number and B1 is
tricks and better ways.
On Wednesday, February 10, 2016 at 4:52:09 PM UTC-8, Paul Bevins wrote:
>
> Guess, I could add that I've used:
>
> Concatenate ("",A1) to give me all my zeros.
> Right (A2,5) function, to reduce the number to just the five digits, or
> six to gi
Hi, I'm Paul.
Just a normal guy, I like to think of myself as tech savvy & have had a
business at various times supporting both PCs and Microsoft in general.
That said, Not always so good with Excel. Hoping to get some tips.
Paul
On Friday, June 8, 2012 at 12:21:59 PM UTC-7, Ayush Jain wrote:
?
Also, While I can just copy the column and paste values, I'd PREFER the
numbers to already be numbers and not formulas looking like numbers.
(That's not a biggie, but would be nice.)
On Wednesday, February 10, 2016 at 4:27:58 PM UTC-8, Paul Bevins wrote:
> Hi, I've got an odd problem.
&g