I need some help and haven't had luck searching for it on here. I have a large spreadsheet that has location info in column A. The rest of the columns...

if I have a row of #s and I want the sum to include only the positive #s, what kind of formula could I write to accomplish this?

I am trying to get rid of the "zeros" and "#DIV/0!" in a cell with a cell a percentage formula. Example: Column A2 = Numerator Column B2 = Denominator Then...

I got a workbook named "Monitor Book" in which I need to lookup for the targetvalue of a reference "ITEM" in cell a1 from another Book named as "DATABASE". I...

I want to arreng my raws in Pivot table. In advanced option, It said, "you can drag items to rearrange them", but I can't do it.

I got a workbook named "Monitor Book" in which I need to lookup for the targetvalue of a reference "ITEM" in cell a1 from another Book named as "DATABASE". I...

Is there a way in which I can use countifs function to count cells that contain a time between 09:00 and 17:00? If not is there any other function I can use...

Hey guys, I have two colums "A" & "B" with dollar values all the way down in each (500 rows)...I want to conditional format them quick...so IE: If A1B1 then...

Is there a function that can work out from a date (in format dd/mm/yy) whether the date falls on a weekend day i.e. a saturday or sunday? Thanks John

I have multiple price tables that go along a worksheet that are for different products. For each product there is a: Low High Average These prices are...

Hello from Steved in Cell A1 I have 5854, now picking up the first digit which is 5 it will type in "Shore" Please how do I ask the bottom Formulas to do...

One mo- 1. How can i set a formula which shows 2nd last Monday of the month? A1 = 2009/07/10 A2 = 2009/07/20 (a formula which shows 2nd last Monday of the...

I've been through all the questions in here and I'm still having difficulty grasping this. I want to conditional format dates that are 60 days, 30 days out...

I have a list of 16,0000 recipients each of them has products from 1-41 unfortunately the data provided doesnt put the products in each column properly....

Hello and thanks for taking the time to look and try to help I have a list of info on sheet "open orders" with columns A=SO#, B=ID#, C=QTY, that uses a choose...

Good Day, hope that you possibly can help me. I tried below function in an Excel sheet. It works well until I change the text to display for the hyperlink,...

Hi, Trust I explain this easily and someone can help. My spreadsheet has three columns; date, unique venue ID number and a value - eg Date Venue Number...

I would like to know how I can set a formula which shows that date of next wednesday..... e.g today is 2009/07/01 (A1) how can the cell will pop the value of...

Hi- I'm interested in a formula medthodology rather than pivoting and advance filter. I'd like to look up numbers that are duplicate and more than one...

Hi, I am trying to SUM a column with two criteria between two dates. i.e. SUM "Revenues" by "product" and by "customer" between two dates to create a search...