Gamingforce Interactive Forums
85242 35212

Go Back   Exploding Garrmondo Weiner Interactive Swiss Army Penis > Garrmondo Network > Help Desk
Register FAQ GFWiki Community Donate Arcade ChocoJournal Calendar

Notices

Welcome to the Exploding Garrmondo Weiner Interactive Swiss Army Penis.
GFF is a community of gaming and music enthusiasts. We have a team of dedicated moderators, constant member-organized activities, and plenty of custom features, including our unique journal system. If this is your first visit, be sure to check out the FAQ or our GFWiki. You will have to register before you can post. Membership is completely free (and gets rid of the pesky advertisement unit underneath this message).


Putting mismatched text strings into an Excel pivot table
Reply
 
Thread Tools
Radez
Holy Chocobo


Member 2915

Level 31.81

Mar 2006


Reply With Quote
Old Jan 27, 2009, 10:26 AM #1 of 10
Sorry man, all I can suggest is to build the list of text strings you want to search for, replace all the descriptions with those standards and pivot off of that. That is, combine your formulae together to get something like

IF(ISERROR(SEARCH(F$1,$C2)),$C2,"POST")

Copy/past-values and iterate for however many accounts you're looking for. That should at least catch the majority and then if you need to manually edit the rest.

Jam it back in, in the dark.
Reply


Exploding Garrmondo Weiner Interactive Swiss Army Penis > Garrmondo Network > Help Desk > Putting mismatched text strings into an Excel pivot table

Forum Jump


All times are GMT -5. The time now is 05:55 PM.


Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2026, vBulletin Solutions, Inc.