Hello, I have a dynamic array that returns five columns of data. Is there a way I can multiply two columns together, and then add this total to another column and then output this one new column into another array?

Hi there, I've only ever done a little work on excel before and i'm currently trying to create a pretty basic stock inventory. I have 4 formulas per line calculating sizes, volume, prices etc which all work and are linked to fixed references. Everything is working fine but the spreadsheet is...

I created an Excel spreadsheet that I sent to numerous people to fill in with data. Everything works fine except for the spreadsheets I get back from one specific person. Under normal circumstances, the spreadsheets from this one person open a trifle slower than those from any of the other people. BUT...

Hello Experts, I just changed some code I had and something surprising stopped working. Basically, I used to have the program poll through a bunch of xls files in a directory, import the data from them, quit the Excel object, and rename the files to *.old. This worked fine. Now I need to change the function...

Excel Experts, I need to create a summary sheet that will automatically summarize a list of all the similar (alpha-numeric) items in a column on another sheet and give a count of how many items are in each different group. What would be the best method of accomplishing this? This would be similar to...

I currently have a cell that I am performing this if statement for =IF(H8=1,(VLOOKUP(I4,rentaltable,2)),IF(H8=3,(VLOOKUP(I4,rentaltable,3)),IF(H8=6,(VLOOKUP(I4,rentaltable,4))))). What I would also like to do is check another cell in the spreadsheet to see if its value is "Double" or "Triple"...

I everyone- I have the following code that works great (see below). I just need it to also bring in the column headers (Field names) as well. Can some help me with how and where to insert the necessary code that will also capture the column headers. Thanks so much!! Code Snippet: 1: 2: 3: 4: 5: 6: 7...

Hi, The below Vbs file gets the Ram slots and the free slot details of all the machines in the file with the size per Bank. I have the machine names in Colum Q Need the output as such. Total Slots Free Slots Bank1 Bank2 Bank3 Bank4 ^ Colum "AE" ^ Colum "AF" ^"AG" ^"AH"...

Hi, Excel macro to get mac address of all the machine names in Colum Q.Results to Colum AD. In my inventory excel.I have a colum of machinenames can i get the mac addresses of all the machines in the excel. Results in Colum "AD" If blank then leave the cell blank. REgards Sharath

Hi all, Brad (byundt) said in http://www.experts-exchange.com/Applications/MS_Office/Excel/Q_21245395.html that the REDIRECT function is volatile, and INDEX is not. This is a very interesting and valuable learning. Can someone point me to a definitive list of (a) which functions are volatile and which...