Log In
Register
Home
New Member
May 9, 2019
Offline
hello group
i attach sample schooldb. my request
1- Id-School without duplicate Id
2-Id-School duplicate Id to school
3-First bench and First bench in all school
many thanks
VIP
Trusted Members
December 7, 2016
Offline
Hello,
I am not clear with what you want help with, I don't see any formulas in your attached file.
VIP
April 21, 2015
Offline
Hi Mohamed,
Can't help you with all three questions, but fixed the last one. @Anders: I think he is looking for formulas and that's why they can't be found in his sheet. The questions are in the sheet.
Mohamed: I splitted the cells back to normal in your columns I and J and put a MIN and MAX (with conditions, don't know how they are called in English, but you'll find them in the cells). That'll do.
There is a trick for your other two questions, I saw recently on Sumit Bansals website (Trump Excel), but can't remember how to do it. Maybe you can look yourself there, or somebody here helps you.
Good luck!
Frans
VIP
Trusted Members
June 25, 2016
Offline
Try this
Part 1
In cell F3 enter =IF(COUNTIF($B$3:B3,B3)=1,MAX($F$2:F2)+1,"")
Part 2
In cell G3 enter =IF(B3<>B2,MAX($F$2:F2)+1,G2)
Copy the formulas downward.
Hope this helps
Sunny
1 Guest(s)
