Each Federation Name should be come with separate state and federation code like mentioned I column
Need Formula from I2 column
Each Federation Name should be come with separate state and federation code like mentioned I column
Need Formula from I2 column
In I2:
=LEFT(VLOOKUP(F2,TRIM($G$2:$H$13),2,0),2)&SUM(IF(F$2:F2=F2,1/(COUNTIFS(F$2:F2,F2,J$2:J2,J$2:J2)),0))
**Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).
Then copy down.
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.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Or try in I2 and copy down:This is also an Array-formula, so confirm the formula with Ctrl+Shift+Enter.Formula:Please Login or Register to view this content.
Last edited by HansDouwe; 12-19-2023 at 04:56 AM.
Its not working mam, K14 and K16 and K17 should be TN1 but it shows TN2. Aligw mam.
Then go with the other option offered by Hans.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks