LinkBack URL
About LinkBacks
Hi Everyone,
I am looking for a excel function which is able to count the number of times data shifted from any integer value to null value. Attached demo file for better understand. Thanks in advance.
required demo.PNG
Hi Everyone,
I am looking for a excel function which is able to count the number of times data shifted from any integer value to null value. Attached demo file for better understand. Thanks in advance.
required demo.PNG
Try this:
=COUNTIFS(A2:P2,"<>",B2:Q2,"")
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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
The only way I know you can count colours in cells is with a UDF.
You can find one here; https://excelribbon.tips.net/T011725...th_Colors.html
You could then use this formula to get your result;
Formula:
=(countCOLORIF(B3,B3:Q3)+countCOLORIF(F3,B3:Q3))/2
Any use to you?
It's not a colour count question, Paul - the colours are there just to help illustrate what's required. It's counting when there is a null value after an integer.
Hi AliGW,
It worked as accurate as per my requirement. Thank you so much for saving loads of time.
Hahahaha - That serves me right for trying to help before I've got enough coffee in my system.
#FAIL
You're welcome!
Paul - been there, done that, got the T-shirt!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks