Thanks DO, the prediction of how many times it will be sent/received was just wishful thinking!
Ok so if i were to put a column in titled "No. sent/received", with simply a number 1-4 how could i link that in to the equation so it shows if its complete or not? Thanks
WTB
Well, if you can assume that the number of sent/received won't exceed the number you stipulate then the calculation is in reality simpler.
Let's assume the 1-4 value is entered into Col J.
Based on your file (J3:J8):
4
3
3
2
3
2
Then
K3: =IF(COUNT(C3,E3,G3,I3)<J3,"Incomplete","Complete")
copied down
would result in (K3:K8)
Complete
Complete
Incomplete
Incomplete
Incomplete
Incomplete
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
WTB 
Register To Reply
Bookmarks