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!

Register Log in
  • Congratulations derfloh 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: Jaffey
  • Order by date
  1. Jaffey

    filter matching records on two tabs

    I have a spreadsheet with two tabs containing payment information, one internally generated and one from the client. My goal is to flag, or move to a new tab, the unmatched records so they can be investigated. Each record on both tabs has; Name, Acct#, PmtAmt, CommAmt, Date, and PmtType. A...
  2. Jaffey

    Excel not accepting values as "time" from Access

    I have an Access query that passes phone switch data to an Excel Pivot Table. I use the following expression to parse the date Time: Mid([CallDate],13,5) which gives me normal looking time values like 14:52 11:33 18:21 etc. This is fine for display purposes but Excel is not recognizing them...
  3. Jaffey

    select last name only from full name

    That's great. Thanks John.
  4. Jaffey

    select last name only from full name

    I use that frequently for other purposes but it is not an option here. I was hoping to do it with a single formula. I know I can use LEN to select, say the first 10 characters, in the name but I'd like something that stops at the comma. I suspect there is a way to do it with LEN and SEARCH but I...
  5. Jaffey

    select last name only from full name

    I have a column containing "lastname, firstname" I would like to have the last name only appear in another column. Can someone please tell me the formula to use? thanks!
  6. Jaffey

    auto colour different names

    I have a table with 4 columns; - agent name - department name - sales total Each day the table is sorted by who brought the most money in. I would like each dept. to have it's own font colour and/or shading to make it easier to spot people from the same dept. There are 12 different departments...
  7. Jaffey

    how hide FALSE?

    Thanks Gavin! I had actually tried that in my formula but I had ended it with one of the brackets in the wrong place....ABS(AH8),""))....doh Thanks very much.
  8. Jaffey

    how hide FALSE?

    ...The actual formula I'm using is =IF(D8>0,IF($E$4>0,(D8-AB8)/$E$4,ABS(AH8))) D8 = quota $E$4 = # days left in the month AB8= mtd commissions AH*= +/- quota So what is really says is, if you have a quota and there are still days left in the month, subtract your current commissions from your...
  9. Jaffey

    how hide FALSE?

    I would like to hide cells where the formula displays "FALSE". Turning the text white would be sufficent but I can't get it to work with conditional formatting.
  10. Jaffey

    hide rows with zero values

    I'm sorry but I can't find that. How do I enter it?
  11. Jaffey

    hide rows with zero values

    I tried that but before....it works but you have to reapply the filter every time a new row becomes populated so it's not a satisfactory solution. Thanks anyway.
  12. Jaffey

    hide rows with zero values

    I have a table of data with 'desk' names down the left hand side and the days of the month across the top. Each day the revenue for each desk is entered beside it's name under the column of the corresponding date. The table is 300 rows by 31 columns. I have created a report on another tab that...
  13. Jaffey

    how combine text and date display in word wrapped cell

    I want to display "Posted on Mar 14" as a column label. The date portion is to be grabbed from another cell. I also want the label to be word wrapped so it doesn't take up so much space. I have tried using =Concatenate("Posted on ", A1) and it wraps fine but I can't the date to display in date...
  14. Jaffey

    need to display most recent data only

    Thanks Skip! Your formula works great. I agree completely with your comments but unfortunately they have been doing it this way for many ways. One question, your formula returns an error if none of the cells in a row are populated. This happens from time to time when agents take time off etc...
  15. Jaffey

    how show yesterday's data only

    thanks, I thought the problem might require a VBA solution as opposed to a formula
  16. Jaffey

    need to display most recent data only

    I have a table that shows how much revenue each agent brings in each day. The agent names are in the first column and the days of the month are labelled across the top in the first row. Each day the previous day's revenue numbers are entered in the column for that day. I would like to have a...
  17. Jaffey

    how show yesterday's data only

    I have a table that shows how much revenue each agent brings in each day. The agent names are in the first column and the days of the month are labelled across the top in the first row. Each day the previous day's revenue numbers are entered in the column for that day. I would like to have a...
  18. Jaffey

    need hourly reminder

    that's exactly what I'm trying to do....there is no hourly option
  19. Jaffey

    need hourly reminder

    Maybe I'm just blind but I don't see how I can make an hourly reminder in the calendar under the reoccurence options. Anyone know how?
  20. Jaffey

    want better email reminders

    I've tried both of those as well....but then you are presented with either a task item or a calendar event and you have to create a new email or find the original one to send it again...I just want the original email to pop up again 10 days or whatever....I've resorted to forwarding emails back...

Part and Inventory Search

Back
Top