alternative

Hi Community, I am using Excel 2010. I have a problem with the formula below because it makes the workbook VERY slow: =IF(B$2="",0,SUMPRODUCT(SUMIF(INDIRECT("'"&Tabs&"'!B25:B245"),B$2,INDIRECT("'"&Tabs&"'!L25:L245")))) I am trying to do a SUMIF in 80 worksheets (named range 'Tabs') and the...

Hello Everyone Im wondering if anyone knows of a faster alternative to this Array formula- {=INDEX('(System) SC Country 1'!$C$5:$C$5000,MATCH(0,IF(('(System) SC Country 1'!$D$5:$D$5000="Incomplete")*('(System) SC Country 1'!$G$5:$G$5000="Routine")*('(System) SC Country...

I have a need to be able to discover if there is anything on the Office Clipboard. An item count would be perfect. I am using 64 bit - but can usually adapt 32 bit instructions. I am reluctant to try the alternative of using the system as this would raise a whole new range of questions - though...

Hi, I have the code below which I have used before but it doesn't seem to want to work anymore? Can anyone see what's wrong with it or suggest an alternative as simple as this to concatenate a range of cells? many thanks. Range("AE4").Select ActiveCell.FormulaR1C1 = "=combine(R5C29:R10000C29)"...

Would anyone know an alternative to Offset? I'm using a table, so my current code is: For each c in Range("Table1[Entity Code]") If c. value="x" Then c.offset(0,-16).value="y" End If Next I'm hoping to do something more along the lines of: For each c in...

for my understanding using sendmessage is a more reliable way to simulate key press then using sendKeys How can i replace this line of code: SendKeys "^a" With a sendMessage alternative?

I am trying to make user friendly names into database friendly names. I have a list of 2000+ field names that I've been trying to cut down to a format I can use for our database. For example: "Drawings Issued" >>> "DWG_ISSUED" "Quote Received" >>> "QUOTE_RECEIVED" "Project Manager" >>> "PM"...

hi I have a spread sheet which has a few thousand formulas similar to the one below causing the spreadsheet to take a while to calculate whenever an entry is made is there an alternative to the formula below - im using excel 2010...

I have the following code to delete a row if the value in column C is Monday. My question is, if there is no Monday value will there be an issue, so far I have run the code and I do not see any problems. Is there an alternative. Thank You Code Sub DeleteMonday() Dim lr As Long...

Dear all, I use Ctrl+Home button very frequently in excel. I have purchased new keyboard where Home and End buttons are not available. Please guide is there any alternative keyboard shortcut to get the same functionality of Ctrl+home/End button? Appreciate a lot. Thanks

hi I want to place this array formula as it is too slow to process. please could you help me find an alternative solution formula {=MIN(IF($P$2:$P$50000=P3,IF($U$2:$U$50000<>"Fuel Card",$AM$2:$AM$50000)))} Many thanks

Hi, I'm building a stock management system, and I need a formula that looks through a range of codes on each worksheet in a workbook. It adds the number in a specified column on the same row, and brings the sum of these numbers back to a summary page. Basically it adds up total usage of...

Has anyone used Alpha Advantage APIs with excel for importing live stock prices? Yahpoo seem to have dumped their API with no notice and saw this mentioned in a thread as an alternative.

I've created a spreadsheet that uses the barcode font to create a barcode linked to specific data. The problem with this is that the sheet will be disseminated to users who likely will not have the barcode font installed on their computer. Anyone know of an alternative to this method that will...

Hi all Is there an alternative to using multiple SUMIFS which include date ranges in the criteria? I have an example in Excel but can't see how to attach, can someone please point me in the right direction? Thanks, Craig

Hi, I'm currently working on a Dashboard that is made available to the users through SharePoint 2010. I would like for the users to be able to change currency on the Dashboard so i have come up with a fairly simple solution where the users select currency from a Data Validation drop-down...

Good day, Excel people~! I've been given a little problem to investigate at my work; a colleague has a generic sheet that he wishes to post onto our company Sharepoint so that multiple people may open it and add whatever info is relevant to them. The problem is that these people have a tendency...

Hello there, I hope you can help me with this, im pretty much a newb at this. I got 2 open Excel files, and I would like to press a button in 'Excel file 1' and then it saves the 'Excel file 2' with a name from a cell in 'Excel file 1' automatically (when pressing the button). Right now I use...

I am loomking for an alternative to MS Query. Currently I have three workbooks. Two of the workbooks reference the third wrokbook (DataBase). The DataBase file is a simple excel database that houses data with 100 rows and 125 columns of data. All files are saved on a corporate network server...

Is there an alternative function that performs/mimics the job done by Vlookup/hlookup? thanks for your help