Search results for query: *

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...

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...

That's great. Thanks John.

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...

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!

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...

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.

I tried using ISERROR but FALSE isn't really an error so that didn't help. I supect there is a way to make a formula read FALSE as text but I don't know how to do that. I really just want to supress FALSE from displaying. The actual formula I'm using is...

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.

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

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.

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...

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...

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...

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

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...

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...

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

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?

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...