database function

Hi all I have an existing database in a worksheet, with customers arranged down the rows, and variables for the customers arranged along the columns. I then have a separate worksheet which acts as an 'At-a-glance' page whereby you choose the customer from a drop down list and a series of cells...

Hi - I have three acquisitions which will occur in different months (i.e. one in Feb; one in Apr etc): <colgroup><col><col span="6"></colgroup><tbody> Timing of Acquisitions Jan Feb Mar Apr May Jun Acq1 1 Acq2 1 Acq3 1 </tbody> When acquired, each acquisition...

Dear all, I am confused about array in Sumifs formula and after browsing several thread about sumifs, i know we cannot use formula such as =SUM(SUMIFS(E3:E10;B3:B10;B14;C3:C10;{"dog";"cat"};D3:D10;{"male";"female"})) and should replace with sumproduct formula, but what if i still need the first...

Hi, I am analyzing a large amount of data for a project, and so I am attempting to use the Database functions within Excel to speed up the analysis. However, after I set up the first set of DSUM equations, my file size jumped from ~50k to ~40MB! Any help would be much appreciated. Here are...

I have a spreadsheet with following columns - User ID Age Height Body type Complexion Diet many other like this I want to create a database such that, For E.g. if someone selects age between 23 to 26 and height 5.6 to 5.9, body type as average, then it should pick all filtered data (as per...

Hi, I am using Dmax, Dsum formulas to sum the values (in column A) associated with a given serial number (where the serial numbers are in columns B, C,......). The strange outcome I get is that for a given serial number "UMC1", my summed values include those associated with serial number UMC1...