I have a spreadsheet where there is one invoice number with muliple lines. The shipping charges are recorded in each row even if there was only one charge....

This is an extract of my source data with thousands of records. I want to know the no. of cutomers (unique count) associated with each product without deleting...

=SUMPRODUCT(--ISNUMBER(H21:H51)),H21:H51)/COUNTA(H21:H51) -----CTRL SHIFT ENTER THis forumla works for averaging without adding numbers that are but how...

Hi Excel Gurus; I have another problem. I have 2 worksheets - data source and a summary worksheet. The source data worksheet has the following data : A ...

I need to find the MAX of a column of numbers that contain in them with out putting the less than in a separate colum. Example: 2 0.1 8 7 3

I'm using Excel 2007 and I'm trying to calculate XNPV for a certain array within VBA. Within Excel, the XNPV function asks for 3 arguments:...

I am not sure what to use but here is the situation: I have a macro that Ron Bruin brilliantly helped with that combines data in several tabs into one summary...

Hi, I would like to create a hyper link from one cell entry that opens two to five different files. I can make the connection manually, dont need that to...

Hello I would like to know why some times my formulas don't work and 5 mins. after they do. Do you have an explanation for this problem. Thank you for your...

I have a worksheet which contains 6,000 rows with subtotal amounts. When I hit = to begin the calculation all hidden cells expand, which I don't want to...

I'm trying to do a simple calculation in a worksheet that contains hidden/subtotaled cells. When I enter = to begin the calculation all hidden cells expand...

I have an inventory worksheet with many rows, where column D is a manual entry of item length, column E is a manual entry of item width, and column G is the...

Ok, this has been a very helpful forum so here goes another. I have 3 columns D2 (with a date ie 20 Aug 09), F2 (with a date or not ie 22 Aug 09 or blank),...

I have multiple sheets. One sheet identifies the date a ticket was closed and the ID of the technician that closed the ticket. Open Dt Closed Dt ...

Hi all, I need your help again! I have two worksheets. worksheet one is the source Worksheet two will contain the formula worksheet one:

Hi, The Problem: An excel sheet has a list of names. Another excel sheet with some additional names Is received. I want to identify and mark the new names in...

Hello, In this worksheet all the details of every invoice are shown in columns: invoice value, weight, destination, customer, etc. There is 1 row per...

I need a example of how to do this... to check conditions of other cells CF conditions. In cell A1 - In the "Conditional Format" section "Condition 1" ...

Hi, well stuck and I`m sure it`s simple but have tried everything: I think! Using the following very successfully BUT... Now I want the second and the last...

I have been trying for over an hour to get a formula to work. There are 4 specific items included in a column and 1 item in another column that if all of...