I am trying to merge/consolidate two spreadsheets into a third spreadsheet. See example below. List 1 Name Info Mike Good Guy List 2 Name ...

By dragging the black rectangle at the bottom of a cell, you can automatically increase a number by plus one while moving from one cell to the next.. Is it...

I am trying to simply divide one cell by another. However one of the cells (A1) contains a formula from another calculation, and no matter what I do it...

Hi I know how to create drop down lists in data validation but I am looking to get a little extra. Currently I create a list in A1:A10 create a range name...

My spreadsheet has many formulae with Names. I want to view the sheet with the actual cell references instead of Names .. how to?

Hi, I am creating a large matrix analysis of for my company. I need the value of each cell (0 to 1.0) in my matrix to be displayed in different colors...

this is a bit off topic. I come here to ask about a problem in Ms word as there are no good MSword forums out there. Maybe some of you have experineced this....

Am designing a spreadsheet template to consolidate daily operations information into a one page report. Have tried using Word forms with fields which does a...

Data is as follows: A1 099 A2 99 A3 099 A4 99 The cells are all formatted as TEXT In A5 is a formula =COUNTIF(A1:A4, A1) The result incorrectly calculates to...

Hi, Is there any way of counting the number of characters within a cell without having to do the text to columns thing? I have many screen captures of TRAU...

When I am in column A and click TAB to move to column B, it jumps to column M. I do not have my cells protected or locked. Can anyone help? --...

Hi Everyone, My excel skills are basic so hopefully you'll understand what I want to do... I have created a sheet with headers/titles at the top of the ...

-- Ference

I'm new to excel and I've recently encountered a problem that's even stumped my teacher. I'm hoping one of the whizes in this forum can help me: Say I have a...

Hello, Any help would be greatly appreciated. I'm trying to count the number of occurences of a number in on column and then a y or n in the second column...

Hi everyone, I have spent the better part of the last two days trying all kinds of ways to merge two columns together with next to no success. I'm sure this...

We have a list from our school district that needs to have spaces inbetween the typed in fields. When we add new prople to the list and try to sort it, we...

I've applied data validation (list setting) to some cells in my workbook. The source is a named range in another sheet. When I click on the cells with...

Hi all, Standard conditional formatting of a cell is based solely on the cell's own value. Is it possible to make it depend on the value of another cell? ...

I have a column of numbers that I sort based on the first integer. For example, I want 2 4 77 555 777 11111