I'm doing some extensive solving to find both the min and max values for a particular formula based on a whole table of data. The solver finds the optimal...

Greetings, I have 6 cells A1 - A6 with dates. Approximately 23000 Rows. They should be the same, however, fat-fingers are involved making inputs. What can...

I want to creat 1000 columns in one Workbook, how do I perform the task, and is there a limit to the Columns I can get in one Workbook. It has to be in one...

Am trying to lookup data from different worksheets in the single workbook. Using vlook function but is very time consuming, doing the vlook for every...

Hi to all the much-smarter-people than me out there!! I've got a spreadsheet that I want to automatically insert names into a sheet based on different shifts...

Hello, I hope someone can help me. I am trying to create a forumula for calculating TAXABLE SALE AMOUNT. I will know 2 things. 1. That the sales tax rate...

What would be the best way to create a formula that will return a list of consecutive #s when the list of dates are missing weekends and holidays? What I want...

Hello guys this is my first post. I am having a issues with tracking information from multiple worksheets in the same document I have listed the names of...

I am trying to practice creating a Pivotal Table but do not have any multiple sheet data.

i am makeing a worksheet that needs to calculate scores 200 or under is a pass over 200 is a fail and i want blanks left blank. the fornula i used has the...

I am trying to filter a list that has a column of start dates, and a column of end dates. I want to ONLY show the end dates which are still in the future. ...

On one sheet I have a long list of items which I need my users to scroll down and, when needed, fill in a value next to the appropriate item in the list. ...

I am trying to merge contents of two adjacent cells. What I get i sthe formula and nto the result I have used "=a4&b4" and ="Concatenate(a4,b4)" and they...

I am building a spreadsheet with groups of 2-8 rows merged in column A. Is there a way to insert a conditional page break if a specific group of merged cells...

Hi, I have sheet: In A column exist date In B column exist "x" or null In C column please bulid formula: first or last day in month only for day if in column...

I have a years worth of dates in Col B and need to do countif and countblank in Col D but I need to seperate by quarters, I was thinking of doing it w/ an...

Hi our schedule sheets now need to be encoded with a specific letter or symbol for each possible shift. This include upper and lower case letters. and most...

Is there any way to fill down formulas w/o dragging the + cursur. I'm working on sheets w/ 50K records and dragging is time consuming. Thank-you Zb

Please help me write a SUMPRODUCT formula I have 3 columns A=arrival time C=time 1 D=time 2 I would like column B to show a count of how many times Col A...