density

  1. S

    How to shift rows without copy paste

    I have a large no. of entries in excel like below: <colgroup><col span="2"><col><col span="5"></colgroup><tbody> <colgroup><col span="2"><col><col span="5"></colgroup><tbody> BOAT NO LOT NO Density STATUS F2/146 5820 10.48 10.49 10.48 10.5 10.49 ACC 10.49 10.49 10.49...
  2. O

    Create a new table without empty data rows

    Hey all, I asked a few weeks ago something like that, but now I would like to upgraed my question. I have a big data base (In range A2:P12), I would like to create the table in range F14:I17, The Cell F14 is a data validation list with all metrials. The table in range F14:I17 show only the...
  3. O

    return value based on lookup of two criteria

    How can I add to this formula to find the closest result in my temp. column? If I enter an exact temperature it will return the correct result. Ex: -17.56 = 1.11759 My formula is: =INDEX(C2:C8, MATCH(G2&G3, A2:A8&B2:B8, 0)) Any help would be appreciated...
  4. A

    Geocoded Sales Densities

    I have a data dump of sales transactions with corresponding dollar values and delivery coordinates (latitude and longitude). I'd like to run some form of cluster analysis to output a ranked listing of where the highest to lowest density of sales is based on an input of an X-mile radius. I'm...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top