Hi there,
I need help on my excel sheet.
I am curently working on excel and as you can see on the first image, it is my target, on the second image it is what is automatically does. I want to go over a cell without changing the counting.
Hi there,
I need help on my excel sheet.
I am curently working on excel and as you can see on the first image, it is my target, on the second image it is what is automatically does. I want to go over a cell without changing the counting.
It sounds like you want the numbers within the text in column A to be strictly sequential, not skipping any numbers if there are intervening rows.
But column A is just values, not a formula. How are you putting that data in the file?
If you want to replace the text in A with a formula, put this in A4 and copy down.
Formula:=IF(C4="","","FUNC_"&TEXT(COUNTIF(C$4:C4,"*?"),"000"))
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
Thank you 6StringJazzer for your reply. I didn't explained very well the situation.
I wanted a formula that enables to get automatically to go from FUNC_032 to FUNC_034 without changing the format of the line 37.
I would like a system of drag and drop of the formula without changing the format of the line 37.
In A4:
=IF(C4="","","FUNC_"&TEXT(COUNTIF(C$4:C4,"<>"),"000")) (or Jeff's similar alternative above)
Do NOT copy down!
Instead, select A4 > CTRL+C > select A4:A161 (or however far you need to go) > right-click > paste formula (fX icon).
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks