room no name 125 shiyam 143 jabui 125 slim total No. of room ? i have lot of rooms like this but i just want calculate number of rooms.

I apologize in advance for overstating anything here, I'm just trying to be as clear as possible. I have a "Database" tab where I manage ~1100 records. Each...

After I have created an excel worksheet, how can I make the worksheet look more professional by putting a border around the data and hiding all the other...

Hi there, I have 100 worksheets with different names. At cell f10 of each worksheet... I want to go to cell m95 on each worksheet. If I use hyperlink, I...

Hello, I have a filtered spreadsheet that I can copy visible cells using the edit/goto/special/visible cells function but I want to paste the data in a...

In a list of assessment data I have current test scores in column L and the previous test score in column G. I have a formula that works out the difference...

How do you count the number of times specific criteria is met in Column A, and different criteria is met in Column B. For example, Column A has numbers 1100,...

Okay, so I think my issue with my COUNTIF is that the cells are not next to each other. This is my range: (C3,E3,G3,I3,K3,M3). What I want to do is range all...

I want to create a drop down box using a names list I have saved in a different workbook? Please help me in laymans terms please!!

I have a very simple vlookup function that I am using to pull data from another worksheet. The problem I'm having is that the text I'm referencing as the...

I'm trying to copy a formula. The worksheet has 10 rows of numbers and I want to find what percentage of the total each row equals. As my starting formula,...

Why did MS have the financial function of INTRATE basically use the following formula when it's way too simplistic using the simple interest rate rule that...

I am entering credit card numbers in a column and I notice the very last digit keeps changing to zero. I have the cell unlocked. Any suggestiong?

I have a macro on sheet (1) that takes me to a specific cell on sheet (2). I need the now selected cell on sheet(2) to highlight to some color (yellow...

I have 2 worksheet 1st destination(IR) 2nd source (Amt) I would like to have (IR sheet column highlighted if source (AMT) contains number. I have used...

Dear all, Can any one tell me that if a person likes me who doesn't know about MACRO as well as the VB Code which we usually put for any other function then...

Trying to match 3 fields in one dataset and return a text value in a 4th...

I'm building an audit tool that has a checklist in one worksheet and the report in another worksheet. The checklist worksheet has questions and a YES/NO/NA...

Hi, I have a spreadsheet (Excel 2007) with about 100 items. The below figures represent a sample of the items. I want to calculate the "Score" field by using...

I need the cell A2 on sheet 1 to return a value found in a table I have made on sheet 2 using LOOKUP. The LOOKUP wizard does not really work in this...