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
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...
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...
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...
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...
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 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.