-
I am trying to merge two datasets, and it seems what I am trying to do should be something quite simple, but I am having a brain cramp on how to do it...so, someone, please help.... Here's what I am trying to do: For illustration purposes, let's use Columns A, B, C, X, Y, and Z. I want to write...
-
Hello again! Wondering if its possible with the same example to actually count the distinct values in the given column I'm aware that I can get distinct count (including text) by saying: =SUM(IF(FREQUENCY(IF(LEN(H3:H11243)>0,MATCH(H3:H11243,H3:H11243,0),""), IF(LEN(H3:H11243)>0,MATCH...
-
Hello, Would highly like if you could shed some light on how I can accomplish this. My sheet has three segments. The first being a selection for the users (the user can choose which category they want to view the reports for): Selection # Category Include? 1 Electricals Yes 2 Paper Yes 3 Food Yes 4 Beverages...
-
I've attached an example using match, countif and offset to achieve your goal, and also created a named range to demonstrate how this can be used too. You could also do the same thing in VBA code, though I'll leave that to someone else for now. Also, this assumes that your 'sections'...
-
You can use the OFFSET function to provide you with the result of a cell from a location you either know or calculate (eg you may determine the column according to a year value, and the row according to the month - totally depends on your dataset of course). So if you want to return the value in cell...
-
I'm doing analysis on a large data set, it's of the form below, however there are sufficent coloums to mean it has to split over several worksheets, and transposing the data would not help... this asside for now we'll assume only one worksheet p1 p1 p2 p2 p2 p3 a 3.59 2.55 3.07 1.17 3.84...
-
Can please someone send me the workings in a excel sheet which shows how to create a bell shaped graph. I have 500 data points and i'm struggling to show standard deviation in the form of a bell graph. You help will be appriciated. My email address is : vanse@hotmail.co.uk Thanks
-
Jerry There are several ways ActiveCell.Offset(1,0).Select Is just one
-
Roger and David, Thankyou both for your help. Regarding the use of offset, to she some more light on it's use I will describe the layout of my data: The cells with the lookup formulas are arranged in tables of 9x9 cells, the tables are laid out 2 across, and 64 down the sheet. The look-up value for...