How do I get the highest number from a column?

I'm running a standard vlookup, with the intention being that the user will enter a potential new account name into a field, and the lookup will identify...

HI: I'm looking for a way to use the countif function to look at 2 criteria before counting only the data that matches both. For example, say I have a table...

1. Select a cell in the table, and choose DataFilterAutoFilter 2. From the dropdown in cell F1, choose Legal 3. From the dropdown in cell Q1, choose...

I was hoping someone could help me. I have 7 pages on a spreadsheet the first is the main and pages 2-7 are each sections from the main. I need to know if...

I'm pretty new to Excel, but I thought (and it's beeen my experience) that it ignored blank cells when doing a simple SUM. I inherited a spreadsheet that sums...

I am trying to find a formula that will count 2 columns and return one value. For example : I want to count all cells in column B that contain RI + cells in...

Looks like you want... =SUMPRODUCT(--(Arange=X),--(Arange=Z),--(Jrange"")) "skweetis" wrote in...

Can you format a cell as a date

Dear, Since a while ago (when it still worked) we begin to have problems with one Excel-sheet and Custom Views. The problem is that when we apply a custom...

I have some data that I imported from Access. In Access, it was formatted as a number, but in Excel it imported as text. I can right-click on each cell and...

I have a problem that's been hounding me for the last few days. This is a problem I have in various formulas, but here's a specific. I have a mail list, and...

I have a schedule at work and there are four crews, A,B,C,D. Each crew on the schedule is a different color. I was wondering if there is a way or a macro...

I have a sheet with four columns! a,b,c,d Column A has nothing in it and is labeled id_fm Column B has 2870 rows of customers and is...

I am experienceing a strange situation. I have a workbook (with print gridlines turned on within each worksheet), when printing the entire workbook, I am...

Hello there I'd like a work book with about 45 worksheets to always print in black and white. I've found this staement but it seems to only apply to one...

Is there a way to look in a cell and find a particular string of data and categorize that as "TRUE" if the string is found and "FALSE" if not? I've tried...

It's easy to see data anomolies from the pivot but difficult to find them again in the flat file. Does anyone know if it's possible to change the underlying...

I'm working with large numbers. How can I make the result round up or down to the nearest thousand or even million? Any suggestion will be greatly appreciated.

Hi, Does anyone know how to split a text cell that contains two lines of text (created using alt enter) into two cells which each contain one line of the...