Hi and sorry for the cross-posting but I'm desperate, Does anyone know how to find the minimum of a row of numbers, but only for numbers greater than zero? I...

1. I have a workbook with data that is linked from other workbooks. In this final one I have linked the color score (e.g. RED, BLUE, GREEN, YELLOW)...

I have data in a spreadsheet in excess of 65536 lines so I have the data on more than one page in a workbook. How do I create a pivot table that will use more...

Want the column index number to pull from 3 different cells and show the three numbers?

How can I use a formula to subtract a number in one cell from a number in another cell then display the result only if it is positive or greater than 0?

I need to return a value from another column based on another value I'm using to filter the results. I can use index and match to do...

I need to look up values in a tabel that has subtables. Example: 35376 WEEK 22 MONTH 33 MIN 11 TTIN 44 35377 WEEK 55 MONTH 88 MIN ...

I have dates in A, numbers in B, start dates in C and a finish dates in D. How do I get the sum of the numbers between the start and finish date? I have...

Hi guys, I am trying to create a worksheet that requires an specific item# to be entered into a cell, which has values attached/linked to this. for...

I'm trying do a lookup to find 'min' then lookup to see what month. here's my example: A B C D E F G 1 jan feb ...

I'm trying to calculate average salaries by for a grade within a payroll I've got two named ranges - one is called 'grade' the other 'salary'. These contain...

i have about 5000 numbers(ticket numbers) in block of cells , and i need to find out if any numbers are duplicated with another in any of the other cells. how...

New to excel so go easy please... ...i need one cell to contain two functions with a drop down menu so i can choose which one by name. the functions are...

Hello I'm trying to get a number between and including 1 and 20 i have tried =RAND()*(20-1) thank you Susan

I have a spreadsheet that does the following on a weekly basic, First Name Surname Total SPH Sales £ Attendance % Claire Jepson ...

What is the form of the input required for a Fourier Analysis? Can someone provide an example?

i need to create a spread sheet to use for tick marks through out the day. I need the ticks added up and then totaled by catagory. How do I add the values...

I need to convert a number stated in minutes into a format that reflects Hours and minutes. As an example: 722 minutes = 12 hrs 2 mins

I've "inherited" someone else's office. The Excel on that computer is such if I type an equals and a formula, it puts an apostrophe at the beginning...

Hi everybody. Here is table on sheet1 A B C D E F G 1Order Nr Cust PO Cust Name Order...