Quote:
Originally Posted by defixated
wow, really interesting thanks for that
Quote:
Originally Posted by DeezNuts
why do array tables kill my cpu?
Do you mean array formulas? they take huge amount of processing power if you do it on huge ranges. The formula i posted earlier:
SUM((data!$A$2:$A$1000=$A2)*(d ata!$B$2:$B$1000=B$1)*(d ata!$C$2:$C$1000))
froze my excel when i did
SUM((data!$A:$A=$A2)*(d ata!$B:$B=B$1)*(d ata!$C:$C))
because it multiplies every cell by every cell in that range
Quote:
Originally Posted by guller
I have been using Excel since around version 5.1 and I know all of the basic stuff. I have never written a macro, nor do I know were to begin to write one. Where do I start?
Use the macro recorder then edit it as you need, i posted an example of a recorded sort earlier
Quote:
Originally Posted by guller
Lets say I have several sheet inside of a workbook that have 4 columns. I'll use random numbers here. Multiple sheets would have similar data.
Each row is a different data point consisting of a footage, 2 data measurements, and remarks.
Column A would represent a common measurement say footage for instance. The footages between sheets may or may not match exactly every time.
Column B and C would represent different data measurements at that footage.
Column D would be remarks
Sorry the columns don't line up since this site does not like spaces. (, = next column), * = blank cell in column
Sheet 1
A, B, C, D,
1, 25, 35, Random Remark,
2, 19, 26, Random Remark,
Sheet 2
A, B, C, D,
1.5, 15, 55, Random Remark,
2, 49, 86, Random Remark,
I want to make a master sheet inside of the workbook that would organize these numbers together for evaluation. So the master sheet would look like this:
A, B, C, D, E, F, G,
0.5, *, *, *, *, *, *,
1, 25, 35, *, *, Remark Sheet 1, *
1.5, *, *, 15, 55, *, Remark Sheet 2
2, 19, 26, 49, 86, Remark Sheet 1, Remark Sheet 2,
Column A would be a series of numbers in 0.5 foot increments and may or may not have any information transferred from the individual sheets.
Columns B and C would take the measurements from sheet 1 and place them at the correct footage in the master sheet. Column F would be the remark from that footage.
Columns D and E would take the measurements from sheet 2 and place them at the correct footage in the master sheet. Column G would be the remark from that footage.
Does this make sense? How would I begin to write a macro that would accomplish this. I have seen some (If this = that then do this) type of stuff before but I have no idea how it works. I think that is what I have to do here.
Any ideas? Thanks,
For future reference if you use CODE tags it will preserve your spacing
You wouldn't need to use a macro unless you wanted to automate the populating of column A, but if you are happy entering .5 increments then all you need is a vlookup
Master Sheet
B2: =if(ISERROR(vlookup(A2,sheet1!A: D,2,0)),"*",vlookup(A2,sheet1!A: D,2,0))
C2: =if(ISERROR(vlookup(A2,sheet1!A: D,3,0)),"*",vlookup(A2,sheet1!A: D,3,0))
etc
Is that what you meant?
Quote:
Originally Posted by deesnuts
So basically you excel at Excel
Basically, I also just realised that you are not "deeznuts"