My example chart below tracks 'planned vs actual' dates. Is there a solution for 'Actual' data to...
I have 4 columns in excel. Date, Apple, Banana and Oranges. I have a different sheet where I have a...
I need to send out tailored checklists to clients. What I would like to do is have a table on...
I really need a help. I am to replicate Excel Goal Seek. For better understanding of my concern,...
I'm using Win 10 and have excel 2016. I've earlier used Index array formula in excel and it used to...
I am trying to find a value in a table, then return a transposed (column) which is offset from the...
Can someone help me with the formula here? I have used something like this before ={MAX(IF(...} but...
I am messing with =IFERROR(IF(VALUE(LEFT()) and can't solve it after spending a whole night (my...
I have this giant formula which I want to first check if it returns a zero or not. If it does not...
What would be the best way to calculate the longest number of consecutive "k"s in the table below...
What I Have: In A column i have id numbers and in B column i have date(mm-dd-yyyy). What I...
I was wondering if it is possible to substract 2 hours from the TODAY() function so that when I use...
In the linked spreadsheet I am trying to sum all instances of a column R category (for this example...
I have a spreadsheet that has a column for the date that a document was requested. I want to have a...
I have two tables which have most of the columns have duplicates values. Let help me how to make...
Does anyone know how can I auto-number column "B" based on column "A"? Let me give you an example...
I am trying to figure this out and its been driving me crazy for weeks. I am trying to identify...
I need to write a SUMIF formula with reference to dynamic columns. Here an example. In the cell...
* Read for extra information * I have a 3D data set. The third dimension of this data set is...
I'm wondering if there's a shortcut to the following. I have a product form that customers will...
I have a very old excel template which works fine on all latest office versions. Now I am trying to...
I have 3 col in excel and 336 rows. In the first col I have names of months e.g. October 2017 so...
As we know, formula of NORMINV(rand();mean;Stdev) generates numbers with normal distribution...
I have a table of data. The first column holds all the names of clients. The top row holds the...
Help some VBA help. I have the below code for my Excel: Private Sub Worksheet_Change(ByVal Target...
I have a dataset that contains all baseball games played for numerous years. I am attempting to...
ColumnA has values "June 21, 2018 12:00:00 AM EDT", "September 11, 2018 12:00:00 AM EDT", "August...
I need to copy a formula to the other cell but the cell can be in Nth range. For example: In column...
I apologize for the poor wording of the title but it was the best I could do with the limited...
I'm trying to get rid of some outliers from my dataset. Below is a section of my dataset. ...