LinkBack URL
About LinkBacks
May be this...
Formula:
=IF($E1="","",LEFT(TRIM($E1),4)&"-"&SUMPRODUCT(--(LEFT(TRIM($E$1:$E1),4)=LEFT(TRIM($E1),4))))
May be this...
Formula:=IF($E1="","",LEFT(TRIM($E1),4)&"-"&SUMPRODUCT(--(LEFT(TRIM($E$1:$E1),4)=LEFT(TRIM($E1),4))))
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks