Functions

REALLY easy question
I just don't know excel. period. I have a bunch of formulas like 18+2x and 19+15x I'd like to make a line graph to compare them... (x=1,2,3,4,etc.) How do you translate those into excel-speak? ... 3 Jul 2008 06:21

count the occurance of a particular month in a column of dates
I'm having no luck getting a total count of the number of times a particular month is present in a date column. This is what I've been trying to get a count of the number of dates that fall in the month of July, regardless of the year: =COUNT(MONTH(I$1:I286),7) Can anyone help me solve this little problem... 3 Jul 2008 01:15

Using Tabs within the allow users to edit range while sheet protec
I have an excel spreadsheet that is protected. I have allowed users to edit ranges. It won't allow you to use tabs to enter text across columns. Can anyone assist? ... 3 Jul 2008 01:15

Countif function
I have a table that looks like this: DATE DOW Day 1 Day 2 Day 3 8/1/2008 Friday Camacho Trevino Rivera 8/2/2008 Saturday Camacho Trevino Zepeda 8/3/2008 Sunday Tenner Trevino Zepeda 8/4/2008 Monday Tenner Zepeda Zepeda 8/5/2008 Tuesday Tenner Camacho Camacho 8/6/2008 WednesdayTrevino Camacho Camacho 8/7/200... 3 Jul 2008 04:18

How to convert data from Landscape to vertical
I have a data file with 6000 stores and 45 questions but the data came in this way below and this is sample of four stores with 4 questions store Landscape Fruit Flower Tree -------- 12345 Y N Y N 25565 N Y Y N 35685 ... 2 Jul 2008 23:13

If Then forumal
Ok im really new to this and have been reading for hours. Heres what I'm trying to do. If E4=either.05, .14, .23 then B19=K7IF.05, L7IF.14, M7IF.23 hope that makes sense to someone thanks for any help given ... 2 Jul 2008 22:11

How do I round a number to the nearest .49 in a cell that has
I think both answer were the same, but worded a little differently. But it worked!!! Thank you! "T. Valko" wrote: E3*50%+E3 Is the same as: E3*1.5 I need it to round up (.01 - .48) to .49 What if E3*1.5 = a whole number like 150? Maybe this: =CEILING(E3*1.5+0.01,0.5)-0.0... 2 Jul 2008 22:11

Complicated comparison and highlighting question
I greatly apologize if this is already answered, but I did not find it... Thank you in advance. My Current Data: Sheet 1 (old data): A B 1 ID1 Text 2 ID2 Text [DELETED when compared to sheet 2] Sheet 2 (new data): A B 1 ID1 CHANGEDText 2 ID3 Text [NEW] What I can do: 1) Fi... 2 Jul 2008 21:10

Summ figures that are not struck-through
I have a column of figures and a separate cell that displays their sum. I'd like to be able to exclude from the summing process, the figures in that column that are struck-through. Can anyone suggest a way of doing this? Thanks Andy ... 3 Jul 2008 12:31

Charts not updating
I am having a strange issue with excel and hope that someone can help - The charts within a spreadsheet do not update when the source data is updated. This is a new problem as previously the updating worked fine. The spreadsheet is set to auto calc but the word "calculate' shows up in the bottom bar as if the manu... 3 Jul 2008 10:27