I've been wracking my brain to figure out the right IF or IF/AND statement and I'm stumped. Essentially I have a row of data. Some fields have a number and others are blank. I need a formula to show where there is consecutive data or intermittent data. So essentially, if there is a blank cell after any cell that has data in the row it should be considered intermittent.
Try this
It counts the number of numbers between the first and last numbers and compares that to the number of columns between the first and last numbers. If it's the same, they are consecutive.Formula:
Please Login or Register to view this content.
Last edited by ChemistB; 01-28-2021 at 04:14 PM.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Hello fl0w3r. Welcome to the forum.
Here's another way.
In cell F2 and filled down.Formula:Please Login or Register to view this content.
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks