Formats didn't hold below so I attached a spread sheet to make the columns and rows clearer.Below is a sample of what I have mixed over 45 cells. For all cells in column A that are "FIC" I need the dollars (that are mixed with text in column C) totaled (Column B would be blank). For all cells in column A that are "Outside". I need Column C to just be the dollars (no text). If Column A is "GSU" then I need the number following "Total Value" in column C.
A B C
1 FIC IV1234 MV: $26,453.42***Blah Blah text (IRA)
2 FIC NV1234 MV: $1,307.76***Blah Blah text (IRA)
3 Outside 12345 Market Value: $251,655.62***Blah Blah text
4 GSU 6Z1234 $35.29***MONEY $42,676.95***(PNRA) Total Value: $42,712.24
How can I get totaled and formated something like this:
A B C
5) FIC $27,761.19
6) Outside 4393829 $251,655.62
7) GSU 6ZE155196 $42,712.24
Any suggestions?
Bookmarks