Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: skitrumpet
- Order by date
-
Embaded If Formulas
If only 8550 or 5486 need to be tagged with 3 and this will not change you could use: =if(or(E1=8550,E1=5486),3,1) Hope this helps Adam- skitrumpet
- Post #3
- Forum: Microsoft: Office
-
DSUM multiple criteria single headings
Thanks for your comments guys. I guess I was trying to be too clever and completely ignored the pivot table. I'll keep it simple next time! Cheers Adam- skitrumpet
- Post #4
- Forum: Microsoft: Office
-
DSUM multiple criteria single headings
Hi, Apologies if this has been asked before, I wasn't able to track anything down with a search. Is it possible to use the DSUM formula with one standard set of headings and multiple criteria below them and return data based on each individual row. For example: Product Country Teddy...- skitrumpet
- Thread
- Replies: 3
- Forum: Microsoft: Office
-
Is IsError appropriate? Not proceeding to Then statement
That's perfect. Thanks very much for your help. Adam- skitrumpet
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Is IsError appropriate? Not proceeding to Then statement
Hi, I am trying to write a procedure that if a variable (portfolio), isn't found in a range (term_portfolio), then find an alternative variable (area) in an alternative range (term_area). The problem is that using the following does not follow the Then logic when an error was expected, i.e. no...- skitrumpet
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
