LinkBack URL
About LinkBacks
See attachement
See attachement
Thanks for the reply but actually I don't have to find the row containing the 22, I have the row ID and I have to check if the row contains the given number, i.e. does the row A contains the number 8? No. Does the row C contains the value 35? Yes. etc.
Isn't that what my solution does??? Maybe you failed to spot it ...Originally Posted by MoldyBread
Your attempt seemed to have the range 2 to 6. If you want 22, use this:
=LET(f,FILTER(B2:F4,A2:A4="B"),COUNT(FILTER(f,f=22)))
Last edited by AliGW; 12-08-2022 at 07:49 AM.
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.
Sorry, it was a reply for TDusIsn't that what my solution does??? Maybe you failed to spot it ...
Your attempt seemed to have the range 2 to 6. If you want 22, use this:
=LET(f,FILTER(B2:F4,A2:A4="B"),COUNT(FILTER(f,f=22)))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks