ST Alpha - "Excel help request -- (edited)" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 155

Excel help request -- (edited)

Posted by znufrii Feb 17 '22, 11:33

I need to sort through more than 22,000 values in a list structured as follows:

Fund ID 1
Director Name 1
File number 1
File number 2
…
File number 66
Director Name 2
File number 1
File number 2
…
Etc. etc. for nine directors across each of 38 fund IDs. Each fund should have 594 file numbers, for a total of 22,572. I have 22,523 which means 49 entries are missing. I’d like to not have to tackle this manually. Any thoughts?

Responses:

Nevermind, found the culprit while messing around with a pivot table. -- (edited) - znufrii Feb 17, 11:48 2
- Was it the Spanish Inquisition? -- nm - CinnaBaron Feb 17, 12:00 1
  - Why would anyone suspect the Spanish Inquisition? -- nm - ReluctantCynic Feb 17, 12:07
can you insert a column where you sum the length of all the other fields? -- nm - prayformojo Feb 17, 11:40

Post a message top

Excel help request -- (edited)

Replies are disabled on threads older than 7 days.