Quote:
Originally Posted by SexSearchSuzanne
The problem with Excel is that half the time I come up with brilliant time-saving, easy solutions, and half the time I am baffled. Your question has me baffled. Besides manually copying and pasting and then do a filter, I'm not sure what the solution is.
But since we are on the topic of how to do things in Excel ... one problem I have never figured out is how to combine information for two sets of keywords ... that is, one set of data has keywords and data A, B, and C and the other set of data has keywords and data D. I want to get a report that matches up the keywords with A, B, C, and D. I actually just found a tool online for $50 that seems to solve this problem, but it's not available for a Mac. Anyone have any thoughts on this one?
|
Its odd huh, the simplest things are very baffling but some of the most complex database operations are a sinch. I can do this lookup in about 5 lines of code in perl, but I really don't want to export and re-import the data to do this. I think using macros may be possible too but I'd rather keep this as simple as possible without copying/pasting keywords all the time.
WG