Hi,
I'm trying to create a formula in a table column that sums values based on a date/time range as long as the time difference between any values within the range and the value in the current row is roughly less than 2 minutes. The issue I'm running into is a spill error from said calculation...
Hello,
I am new to Excel and my brain is fried from trying to search the forum for similar questions/answers.
I am trying to populate a column with data based on information from 2 other columns.
In the attached worksheet, I want to populate column E with the names of the clients based on...
Hi everyone, after much searching I found this forum. Really need your help.
I have a workbook consisting of two sheets.
Sheet 2 - data that comes from a filtered table. basically each cell has a formula that pulls values from another table. It could be 1 row, or it could be 100 rows...
Hi all, i am trying to use filter formula to filter out the result, it works, but if every row use this formula, it will cause #spill! error as sometimes return more than one result
May i know is there have any method to update the formula for auto insert the row to avoid #spill? error in using...
I have dates in column A, (but some blanks), then column B has X, Y, or Z.
The zero's were messing up my Countif and including them in the January total, but in the end I managed to count the number of occurrences for each moth by using : =SUMPRODUCT(--(MONTH(A2:A500)=1),--(MONTH(A2:A500<>0))...
Hi Gurus,
I have a defined name referencing a column in a worksheet that is actively calculated.
It is called _5yrDates and is simply Today() - 5 years. Other sheets use this name to grab the same data.
When I close and reopen my file and click on the first cell in the named range, it has an @...
I would like to create a formula for each customer (column A; i.e. customer 1 made 8 purchases, customer 2 made 20 purchases, etc...) to calculate a ratio in column W based on column V. For example, cell W5 should return 0.75 (3 divided by 4; 3 comes from cell V5 and 4 comes from 4 observations...
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.