Hi, I would like to copy a column that updates to another workbook. If the field is blank I will like it to copy over as blank. data is on trust...

Is there a template available for non profit orgs to keep records of team(s) performance?

Is there a way to find repeated words in a spreadsheet, as well as how many times the word is repeated besides using the COUNTA function? I was thinking of...

I have 100 + worksheets which are all the same (except for the tab name they are different per customer), one cell (the same cell for every sheet) has the...

I am trying to write a formular in a cell whereby if the value of an ajoining cell is between 2 and 5, then enter 50. If the value is not between 2 and 5...

By using pivot tables, I am showing statistical data for base pay for several hundred different jobs and need to add statistics for the median. How can i...

5/10 5/11 5/12 5/13 5/14 5/15 5/16 5/17 5/18 5/19 5/20 A X-1 2 D/O D/O 3 4 5 B 1 X-2 3 D/O D/O ...

I need to hide certain columns from users that open my worksheet. I can protect the worksheet as a read-only with password to modify but that does not...

SUMPRODUCT with AVERAGE result Formula refers: =SUMPRODUCT(--(crq!$C$2:$C$65536="Debit...

Is it possible to extract by formula numbers from a code, for example Code Number AS12345WQ 12345 F87654321LD 87654321 HN123 123 I want to be able to...

I have cells where I am trying to eliminate text after the dash, but it gives me errors if the cells does not contain a dash. How can I have it just give me...

I am a new user. Please help with the following How can I reference the last cell updated with numbers in a raw? example colum a b c d e f are days on raw...

I have a formula in a cell...if(A14A15,"Missed","Made) & "FSP" How do I get the text color of Missed to be red, Made to be blue and keep the text FSP...

Is there any way of doing this? Once you click on Transpose the link button becomes inactive. Thanks

Have Excel 2002, want to remove text from cells and leave the numerical data in those cells intact. Don't see a method for this in worksheet functions...

I'm trying to reference pivot table cells in another worksheet; a direct cell reference doesn't work because the data is ever-changing. I figured out the...

Hi, I have a data base in Access that I am analyzing in excel. I move (create copy) the analyzed worksheet from access into my excel workbook. There I have in...

I have a need to have cell with a formula or series of formulas, that can find the right most cell in a specific row that has a value in it. I tried various...

Once I have set up excel so when you double click on a cell the cursor goes to the reference cell. how do I set it up in this way? Thanks

I have a blood pressure tracker on the templates page (Microsoft's) that can handle any year. I just realized, however, that I made no proviso for leap...