I have been working with the same data fields for weeks, pasting in new data and refreshing my data source ranges. I have been able to group dates in my...

I have a question I do not know if it can be accomplished. But I have a spreedsheet with several rwos and the last cell in the row is an email address. Is...

Hi, I used a if condition and whenever the condition is false i have given the formula to return the values as blank (using "" without space). If i apply...

I am hoping someone can help construct some kind of Lookup+Find/Match formula to check a column of numbers using a constant array provided e.g....

I can subtotal up to 2 layers fine, but on the 3rd is where Excel does not subtotal corret. It puts the item I'm subtotaling underneath the "TOTAL". Please...

Is there a simple shortcut key that changes number formats of a selected range to "comma"? Pierre

I am trying to count the number of dates in a list that are between two other dates. I tried this but it just gave zero: =COUNTIF(C11:C23,AND( ""&...

Hi, I have a formula that I have been using to calculate costs based on reference letters, but now want to exclude some of the letters used in it so it...

In the mornings I am given a couple of hand filled out forms for job sites. I have a template saved to my computer and I fill out the basic info, all in...

I want to merge two colomons with text and numbers in them

Hi I have a formula that...

The Workgroup selection does not appear in the drop down "Window" menu. What do I need to download to obtain this feature.

Hi Is there anyway I can add working days to a date? For example: 23-Feb-09 + 10 = 06-Mar-09 Thanks

Hey Experts My Data looks Like this Name City Total ABC Delhi 24.06 ABC Delhi ABC Delhi ABC Delhi ABC Noida 12

Hi! I am trying to separate suffix/first/last name into different column. Currently I work with different formats: Mr John Smith Mr and Mrs. Smith Mr...

I want to be able to have the computer to give me a expiration date at the end of the 6th day starting today

Hi I am trying to input the follwing formula however when using ISERR it will only return the word FALSE. I am sure a couple of years ago I saw someone...

Hi; Im hoping that im making a really silly error here myself but I really cannot see whats wrong and getting frustrated! Im using the Concatenate function...

I have a spreadsheet with style numbers and colors sold over a period. for eg A B DN012 red DJ111 White TS442 ...

on my spreadsheet i have 3 columns; name, date, amount. the names given are of only two people, and the sheet is in date order. NAME DATE ...