Hello, Is there a macro or quick way to highlight alternating rows in color? For example, row 1 would be gray, row 3 would be gray, row 5 would be gray,...

So I have two columns of data, Department and College. I am using the countif formula to count how many times a department appears in the department column,...

Want to protect columns A & B (year & report number being taken by user) Have Drop-downs (w/ values on separate sheet) in Columns C, F, G, H Also want to...

What I am trying to do is to copy the results of a cell, not the actual formula, into a new worksheet. For further explanation, I am using a monthly budget...

The purpose of this worksheet is analyzing content of strings of telemetry displayed as hex characters,in particular parsing and comparing . So I've set the...

How would I write the function in an Inserted Calculated field to a Pivot Report to search Field1 for "Prospects", if present, insert amount from Field2, if...

This is the formual: =IF(AND(L3="Y", M3="Y", N3="Y"), "Y", "N") I am having a hard time to add it in my existing macro. ******** FYI, I have an OR...

I have only two different text throughout column "K" say.. red apple or blue apple and I need to find out how many red apples and then how many blue. Is...

I would like to insert a scroll bar which will allow me to scroll through a range of cells. In other words, I have a range of dates from 9/2/08 through...

I am creating a spreadsheet for my companys NFL picks every week. Every person picks differently and its a master speadsheet. Instead of retyping out every...

I have a very large data set that has 10 rows of non-needed data, then 20 rows of needed data, then 10 rows of non-needed data, then 20 rows of needed data,...

I have columns of data grouped by date, and the number of names on a given day are variable. I want to lookup the number associated with a given Name from...

Is there way to protect a worksheet from editing after a certain date? For example, I input values for the month of June, but after say 60 days I cannot...

Can I specify a top / bottom / left / right amount of space to leave as padding around the contents of a table cell?

I saw a previous post about sorting odd and even numbers, and the formula generates an "E" or an "O". I need to sort odd and even street addresses. I could...

I have a shared worksheet on which the hidden rows and columns keep becoming unhidden. I know it's not another user doing this because the column mean...

I need a formula that will calculate the number of contacts that I make within a particular ethinicity. I have two columns, with the household ethnicity in...

Can someone give me the correct syntax for building a Lookup () formula. The user will give me sheet name (i.e. Sheet1) and I want to use that value to build...

On sheet one I have all Company Names in column A, Addresses in column B and City & State on column C. On a form I created on sheet two (example) A ...

=IF((C29-C26)=0,C29-C26,0) This a IF statement that returns a decrease in an amount with a positive number I used: =IF((C29-C26)=0,C29-C26,0) for the...