estimates made easy

  1. M

    Please help... Link table info to a spreadsheet

    I am trying to simplify my "estimate" database. I keep one workbook with basic estimate info (i.e. date, rep name, customer name, address, phone & email) and then I have to switch to another workbook to enter this same info in and then fill out the data for the estimate. I am trying to create...
  2. D

    Dynamically extract unique records to a horizontal column header with formula Offset?

    Is there a way to do this, =IFERROR(INDEX('[Import A Clean Master Parts File QG.xlsm]A Master Clean Master Parts Fil'!$F$5:$F$59,MATCH(0,COUNTIF($A1:A1,'[Import A Clean Master Parts File QG.xlsm]A Master Clean Master Parts Fil'!$F$5:$F$59),0)),"") using the offset function so that the header...
  3. D

    Dynamically extract unique records to a horizontal column header with formula

    Dear Smartest Excelers in the World I have a list1 in column A starting in cell a1 and a host of other list in column B-M. I would like to extract unique values from list 1 and create a dynamic column Header for a new table. Example: list 1 1 1 2 3 4 4 5 6 7 7 7 New Table with Dynamic Header...

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