Hi
Could someone help me .
A = Batchnumber
B = Date
C = Name
Right now I have a formula, that counts the batchnumber (A) up, if the name i (C) is different.
But the formula dos'nt count up, if the name (C) is the same .
So is it possible to make a formula, that counts (A) up, if both the date (B), and (C) name is different.
Please see attaced file
Thanks for at fantantic forum
batch.xlsx
I think you mean "OR" not "AND"
Try this-
In A3 put a 1.
In A4 put-
Copy down
Please Login or Register to view this content.
Happy to Help
How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html
"I don't get things easily, so please be precise and elaborate"
If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.
Sourabh
Enter formula in A3 and copy down
Formula:
Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Hmm ... can't make it work
I'am using a danish version of excel (2010), and translated both IF, and OR to danish.
Please see attached file with formula in A3Originally Posted by concepo
Hmm ... can't make it work
I'am using a danish version of excel (2010), and translated both IF, and OR to danish.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks