Hi Guys
Please refer attached attached
I have formula to "sumif" I was trying to use "countif" the same way but does not appear to work
Any help would be greatefully accepted
Regards
Bill
Hi Guys
Please refer attached attached
I have formula to "sumif" I was trying to use "countif" the same way but does not appear to work
Any help would be greatefully accepted
Regards
Bill
Think I got what you want.
Yes it will. we just have to figure out how...
If I have helped you, PLEASE click the * and add to my Rep.
Also, if the problem is SOLVED please mark it as so.
try this, copied down...
=IF(A3<>A2,COUNTIF($A$2:$A$16,A2),"")
adjust ranges as needed
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Try this and copy down
=IF(A3<>A2,COUNTIF($A$2:$A$16,A2),"")
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Thank you all so much for you help
ALL work fine for my need
Cheers
Bill
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks