=IF(COUNTIF(AP2:AP204,1)=0,1,2)
When I type that formula into any cell in excel, it'll work, but when I insert it into my CF formula, it doesn't work. Any ideas?
I've also tried:
=IF(COUNTIF(AP2:AP204,1)="0",1,2)
But that didn't work either
=IF(COUNTIF(AP2:AP204,1)=0,1,2)
When I type that formula into any cell in excel, it'll work, but when I insert it into my CF formula, it doesn't work. Any ideas?
I've also tried:
=IF(COUNTIF(AP2:AP204,1)="0",1,2)
But that didn't work either
CF only returns FALSE or TRUE, to format or not. You cannot return a value with CF. What are you trying to achieve?
I have a large range of data on two different lists. I'm using =IF(ISBLANK(C2),"",IF(C2=Companies!C2,"","1")) to find any discrepancies in my data and then going through 1by1 to update the fileds. Once the fields match, they will replace the "1" with a blank cell and thus, makes my formula work. I wanted to apply CF to my headers so that I knew when a column was done without having to go back and check to make sure there aren't any 1's in that column.
Could you please post a sample sheet showing BEFORE and AFTER ? Thank you
See attached. As I go through the discrepancies, I update the data in List1 or List2 so that it matches and thus, clears the 1's out of K2:N5.
Attached is the before and after you were asking for. I wasn't quite sure how to do it when you originally asked. But I think this clears it up.
maybe try something like sum(range)=0
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
That was what I originally tried, but it didn't work as it saw the formulas as General. I tried changing the cells to numbers and it still wouldn't sum them. I'd have to copy/paste as values to achieve that but then it won't auto-update my number's once I correct the discrepancies.
Change your formula to:
Formula:Please Login or Register to view this content.
This will also work
Formula:Please Login or Register to view this content.
The "1" makes the 1 a text value and that is what is causing the problems.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
If you tried the =sum() rule on this...
=IF(ISBLANK(F15),"",IF(F15=A15,"","1"))
It wont work because your "1" is text, not a value. Remove the ""...
=IF(or(F15="",F15=A15),"",1))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks