I need to do a VLOOKUP but find occurrences later than the first one. I've listed out all of my assemblies and all of their component parts like so:
Parent Child Quantity
To list the the children of a particular parent, I need a function that can find multiple occurrences of the parent. I considered...
Hi all,
So after Dicks (nice to read) rambling on golf, let’s do some Excel/VBA stuff again.
I intend to get a bit of discussion on this one, so bear with me.
I’m currently developing an Excel workbook for a customer. One of the interesting things with this project is that it consists of...
Hi all,
For a project I needed a quick way to display the content of an array to the user. I didn’t want to use a worksheet, but opted for a userform. The data I wanted to show was contained in an array. The array contained something like: Description
Before
After Cell Errors
100
10 Corrupt Names...
gullible.info sez:
An average Microsoft Excel spreadsheet document has 1,102 rows and 18.2 columns.
I say: That's 470 rows and 25 columns. I had 408 sheets whose last cell was A1, i.e. blank. I attribute that to two things: I probably have quite a few workbooks that are just code; Most of the workbooks...