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.

Attached Images

	Cover Page.JPG (46.7 KB, 19 views)
	Serial Number.JPG (86.3 KB, 17 views)

• Are S and SC the only prefixes to the serial numbers?
• Where are the departments designated?

Pictures aren't of much help. Better if you uploaded your workbook and gave examples of expected results.

The easiest way is to have a couple of helper columns as rightmost ones in your table (I see you have defined your table as Table, so formulas will expand automatically whenever you add new entries). Later it will be best you hide those helper columns. And in case Table formulas are used, this will be easier when you don't use spaces in column names.

To continue from here, some additional info is needed:

1. What do you mean with 'last S' ? Is it in your example [No.] = S1459, or [No.] = SC1532? I.e. are you grouping data by 1st character, or by string part of [No.];
2. With 'last' you mean lowest position for given group, or biggest numeric part after string part (when later, then you get same result with any sorting order in applied to your Table);
3. How many characters can string part of [No.] maximally have.