| Thread | Last Post | Replies |
|
| Count function | 23 Jul 2007 23:59 GMT | 5 |
I need some help. In worksheet I've column (one) with short strings. I need to known how much times every of them repeats oneself. Somebody can tell me is exists function which it will make this. Thanks
|
| select and extract rows of data to new excel worksheet | 23 Jul 2007 23:03 GMT | 1 |
I have a large pricelist. Want to estract all items containing certain word in description like "wood" to a new sheet. This must be the entire row of information as it is part number, description, cost and quantity etc.
|
| SUMIF & COUNTIF based on dates | 23 Jul 2007 22:36 GMT | 10 |
I got formulas' 1 & 2 from this NG and tried to make come up with the formula I needed from samples posted in this NG but I was not able to. Please help. Columns: G=Amount, I=Date Posted and J=Date Sent
|
| Another Conditional Formatting Formula needed? | 23 Jul 2007 22:34 GMT | 6 |
In Column A I have a list of last names (A4:A3500), and in Column P I have a list of companies (P4:P3500). I'd like to use conditional formatting to change the color of the last name in Column A (A4:A3500) to blue, when a specific company name appears in Column P (P4:P3500). I'll ...
|
| Time to time range formula??? | 23 Jul 2007 22:34 GMT | 11 |
=TEXT(INT(C2*24)/24,"hh:mm") & "-" & TEXT(INT(C2*24+1)/24,"hh:mm") is the formula I'm using. In my spreadsheet, column C lists the time the patient was discharged. I was given the formula above last year from a poster on an Excel website. I was looking at it today and I don't ...
|
| Run Macro for all worksheets | 23 Jul 2007 22:27 GMT | 2 |
I have many worksheets and I have a macro that I want to run for each worksheet. Is there any way I could save my fingers some pain instead of going throw all worksheets and run the macro could run the macro for all worksheets at once.
|
| cell height | 23 Jul 2007 22:03 GMT | 2 |
I am writing a lot of data in a cell and i am unable to see the whole of it in the sheet. I can not view the last of the lines. I can only see all of it if i click on the cell and then the data is visible in the formula bar. Is there anyway around it, i have tried formatting the ...
|
| jobs | 23 Jul 2007 22:02 GMT | 2 |
1ST JOB - DAIRY QUEEN : POSITION-CASHIER DUTIES (TAKING OUT TRASH, SWEEPING, MOPING, MAKING ICE CREAM PRODUCTS....) YEARS WORKED THERE - 3/'96-11/'96 LOCATION - 141 BISCAYNE BLVD. MANAGER - CHRIS
|
| Canadian Postal Code format? | 23 Jul 2007 21:57 GMT | 9 |
I would like to type is our Canadian Postal Code and have a special format that forces the right entry. Our Postal Code consists of 3 characcters a space and 3 more character. Ie "S0L 1G9". It is always a "UPPERCASE LETTER, number, UPPERCASE LETTER, space, number,
|
| How to add (sum) specific cells | 23 Jul 2007 21:36 GMT | 2 |
If i have a colum E1:E20 with a specific letter in each cell like A,B,C and colum F,H,J with specific numbers, how can i ADD values that lies with A only and B only and C only? thank u...
|
| Make #N/A blank if no value is returned | 23 Jul 2007 21:24 GMT | 11 |
Using VLOOKUP some of my values are #N/A. The formula I am using is: =VLOOKUP(1,$X$10:$Z$17,3,FALSE) If the value returned is #N/A how can I make it display blank or null?
|
| IF STATEMENT HELP CHOOSE AND GET COST | 23 Jul 2007 21:06 GMT | 7 |
I have a Dependent Validation data that I need it to complete this statement IF D2=LOCAL,TECH,FACTORY,OR WEB (TYPES OF CLASSES) IS CHOOSEN E2=THE INDIVIDUAL TYPE OF CLASS IS AVAILABLE CHOOSE AND WHEN THE CLASS IS CHOOSEN:
|
| Looking up multiple results with VLOOKUP | 23 Jul 2007 20:18 GMT | 7 |
Is it possible to have VLOOKUP return multiple results? (I suspect the answer is "No"). My "lookup table" consists of project numbers in column A and supported systems in column B (the project number is repeated in each row for which there is a different supported system).
|
| Help understanding what a formula does and why it's 'faulting' | 23 Jul 2007 18:17 GMT | 13 |
With some help I got a formula that works, but only after a fashion Here was my original question: Return last 6 results formula I have a column in my sheet that fills in progressively over a season
|
| What do you call values used with a functions? | 23 Jul 2007 18:07 GMT | 3 |
Working on excel crossword at work and this one of the questions...the answer is nine letters...hope someone can help.
|