Excel Formula for Finding the Last "S" number used

Aklouzek · #1 01-04-2019, 02:01 PM

Good Afternoon!

I am trying to pull information from several tabs onto a cover sheet. The information i am trying to pull is the last or highest "S" which is a serial number that has both Letters and Numbers in it. Can anyone help to point me in the right direction? I have attached a couple snips to give you an idea of what i am looking to try and do. I need to be able to see what the last/highest "S" or serial number was used for each department at a glance, pulling the information from different tabs to the cover page that I am building.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Spreadsheet with "CR" & "DB" in amount & number columns.	bfisher	Excel	4	09-28-2015 07:03 AM
Finding more than one word using "find" or using a vba code	capitala	Word VBA	1	02-03-2014 06:45 PM
Mailing: how to make the "page number" in Word is the same as "row number" in excel w	Jamal NUMAN	Word	1	09-03-2011 11:37 AM
Excel 07 formating 17 cells "Need Formula"	Raner	Excel	2	05-30-2010 02:07 PM
"Microsoft Excel Application" missing in the "Component Services" on win08	sword.fish	Excel	0	02-26-2010 02:09 PM