reference array table

  1. G

    reference cell even the row is deleted

    i have no clue to doing this man, i expect the output is to be the right chart, but on the left chart is what i’ve done i want the cell to still remain the same number even the row is deleted and if i add new no. it still going +1 i need your help guys
  2. T

    How to reference data in a formula

    Hi, I want to use an AVERAGEIFS formula and have a long list of criteria. Is there a way to do the calculation and reference a table that has mapped the criteria to one cell? If I want to calculate the average sales for Part-time employees in that work in London Stores (Zone 1, zone 2...
  3. M

    Updating Multiple Tables and Adding New Tables using a Reference Sheet from Master Workbook

    Workbook A (WB_A)is used by multiple people saved to their local computer. Saved in the same folder is another workbook (WB_B) that is used as a reference. WB_A pulls information from WB_B and populates multiple tables with rows. I need to be able to add new Tables to WB_B so that WB_A can pull...
  4. P

    Converting Sum Formula To Not Count Duplicates In Array

    In the below formula I want to convert the Sum formula to not count for duplicates. I will explain this further. =SUM(($BB$7:$BV$384)*(--(A7:A384=A16)*(B7:B384=B16))) With the above formula I am summing the total dollar amounts in a range based on 2 criteria (2 other columns). I tried...
  5. K

    Losing Absolute Cell Reference

    I have the following formula in a cell on one work sheet: {=IF(ROWS($B$4:$B$4)>COUNTIF('Lab Submissions Ad 1'!$N:$N,"upper"),"",INDEX('Lab Submissions Ad 1'!$A:$A,SMALL(IF('Lab Submissions Ad 1'!$N:$N="upper",ROW('Lab Submissions Ad 1'!$N:$N)-ROW('Lab Submissions Ad...
  6. W

    Can only reference array table for Find/Replace macro from within the ActiveWorkbook??

    I'm using a Find and Replace macro that refers to an array table. I just HAVE to be missing something. There's NO way that the only way to reference an array table that stores values for Find/Replace macro is from only in the ActiveWorkbook I'm currently working; where I have to copy and...

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