Does anyone know how to create a formula for this? I want to get a value in A22 and if that value is greater than 0 (even if it is less than 1), then...

I download data to a spreadsheet and from this I must extract data from different areas. The problem is that the data that is downloaded is not always in the...

can any body guide me that how to protect a single cell thanks AE

I need to count the number of occurrences a number greater than zero apepars under the "pts" heading; can't do anythiing about the formatting (as there are...

I have a wroksheet of 9 individual sheets. In sheet 2 I face a problem today; when I move the scroll bar button, it moves but the rows are static. How could...

Hi, I was wondering if there was a formula to add up cells based on the cell color? These cells have names in them and no numbers For example: Column A ...

Can I create a HYPERLINK from a drop-down list? Thanks Bobby

When I want to replace a number in a formula it always opens a window asking me to choose a file. How do I prevent this and just have it replace the numbers?

Hello. I am looking to reference the last cell that contains data from one sheet onto another sheet in my workbook. The issue I am having with this is that...

i am trying to set up an average days for inventory based on two criteria. i have set up a calculation to get the number of days aged already, but can't get a...

I have created a database of purchase orders. I have my table set up to show gross margins etc per salesperson. I add once a week to my database. After...

Hi, All the following cells are formatted at standard Numeric, 2 decimal places. I have 2 cellsC2 and D2 and type in the value of 80.60. I use =SUM(C2:D2) in...

I’ve been asked to figure out how early an employee typically punches in for work. They want to give her some sort of bonus. I have the punchclock data...

I need report Unique Users on a daily basis then have a monthly Unique Users Total. When I add the daily Unique Users, it should add up to be the same as...

I have a database export file that includes multiple (1100+) blocks of data in a standard format. Per block, the format is: -- The first column is a merged...

I’ve been asked to figure out how early an employee typically punches in for work. They want to give her some sort of bonus. I have the punchclock data...

Sample: Cell A1 26-Mar-08 Cell A2 25-Apr-08 to get "26-Mar-08 to 25-Apr-08"

My problem is this, I have a sales graph for my sales people that needs to collect daily sales per day. I enter the sales as they come in, in "sheet 1" of...

I cannot for the life of me figure out how to have a macro perform a function and then select the next sheet. I can get it to go to a specific sheet, either...

Hello! I use Excel version 2003 SP2 and have a question about calculating the difference between two times. I have the two times in different cells and use...