holding

Hi all! I am comfortable with excel but diving into Visual Basic has been slow. I'm sorry if this question has been repeated a million times. My searches haven't found a workable answer. We have our client files in excel .. example "M, Amanda Qrtly Rpt.xlsx" in 4 different folders. The...

I have the below sumproduct formula which looks at another sheet holding sales orders. =SUMPRODUCT(--('Sales by line'!$J:$J=$E7),--('Sales by line'!$G:$G>=M$4),--('Sales by line'!$G:$G<Q$4),'Sales by line'!$H:$H,'Sales by line'!$K:$K) Col J matches to a product Col G is a date Col H is...

Hey Gang, Having a hard time working out the right syntax for this. I have a working formula that checks if a cell (5th column) in another sheet is not blank. If it's not blank, it places an asterisk in the cell holding the formula =IF(VLOOKUP($B4,'Other Sheet...

I do not like the way Excel includes all open workbooks in a single instance of Excel. There are times when I need them completely separate. I can do it by typing Excel /x in the command. But is there a way to start a separate instance of Excel by clicking the icon and holding a key? I have...

In order to make formulas throughout my workbook to calculate properly, I had to split my main data entry tab into 2 separate tables; one "table" holding the names and the other "table" holding the data. The name table has the possibility of changing with new employees being added throughout the...

Hello, I have a file that I work on a weekly basis to upload item options, and these item options require abbreviations. These are limited to 15 Chars. So Items options are Alphanumeric, have symbols "/" "-" etc and I've been saving the abbreviations also alphanumeric. For example, some of...

I have a tab in a spreadsheet that each month gets a brand new dump of data for 3 different mutual funds. For the month ending 11.30.17 the total number of holdings for all 3 funds was 533 and for 12.31.17 was 544 (they are listed in order... so all of one funds holdings are from say row 2-100...