Hi,
I saw EXCELISFUN TRICK 369. I need to do something similar. I tried to follow his code and couldn't. Then I tried copying it and growing his records and still couldn't get it to work.
What I am trying to do is on the first list use an inventory list. Which could be about 2000 - 5000 records or maybe double that (not sure how big of a list I could use in Excel). But lets say it is the max number (if someone could tell me that number I would be most appreciative).
I then will load a second list, or would load a list into second column. I then want the difference (what is missing) from the second list to appear in the third list. If it can give me the row of where it is in the first list that would be great (not a problem if you can't). I just don't know why the code from that video is not working any help would be greatly aprreciated?
Thanks,
Peter Fraga
(fragapete@hotmail.com)
Hi All,
I was setting up a spreadsheet that was based on the following vid:
http://www.youtube.com/user/ExcelIsF...14/tqCEY5YMyqw
Dynamic sub tables based on a master sheet array formula
The formula in question is:
=IF(ROWS(A$7:A7)>$E$1,"",INDEX('2010Corn'!A$4:A$17,SMALL(IF(Table2[From]=$B$1,ROW(Table2[From])-ROW('2010Corn'!$H$4)+1),ROWS(A$7:A7))))
B1 is the customer I'm looking for, E1 is the count for the customer and the master page is 2010Corn. I have 20 sheets looking to this master page for data. It works great, except for an issue when adding a new line in the master table.
What is happening is when I get to the end of a row, I tab to enter a new line in the table. It takes up to a minute for the cell to change color and for me to regain control of the computer.
I have run a performance trace and while the computer is locked, one of the CPU core's is pegged for the whole time with a processor que of up to 10 items at a time.
My question is...does anyone have any hints how to optimize this formula?
Thanks
Tony
Guys,
i have a set of data
Tuesday, 1 December 2009
2.9246
144.47
2.9246
Wednesday, 2 December 2009
2.9508
144.21
2.9508
Thursday, 3 December 2009
3.0955
143.345
3.0955
Friday, 4 December 2009
3.1156
142.548
3.1156
Saturday, 5 December 2009
3.1156
142.548
3.1156
How do i copy this and transpose it so it reading it descendingly
Eg
Saturday, 5 December 2009
3.1156
142.548
3.1156
Friday, 4 December 2009
3.1156
142.548
3.1156
Thursday, 3 December 2009
3.0955
143.345
3.0955
Wednesday, 2 December 2009
2.9508
144.21
2.9508
Tuesday, 1 December 2009
2.9246
144.47
2.9246
thanks
Just This Video For Fun
http://www.youtube.com/watch?v=0VvjrldlqI0
how do you invert the data in a column?
thanks,
Ernie
hello
i have information in column A that updates every minute
ie:
A1:111111
A2:222222222
A3:333
this information gets filled with more information every minute
second minute
ie:
A1:111111
A2:222222222
A3:333
A4:4444444444444
A5:555555555
A6:66666
i want a formula in column B starting in B1 that shows me latest information in lowest cell in column A
in the first case 333
in the second case 66666
& then in B2 the second lowest information in column A etc etc..........
how can i do this using a formula not an Excel option ?
Hello, im doing RFI logs for architecture, and i cant seem to write a formula that can cover all of my requirements.
there are 2 days, day rec'vd (column C) and also sent (column H)
i need to be able to have it to where if column C is 14 days old, then the column will turn red
if it is not 14 days old, it is yellow
(this is if column H is empty)
however, if column H has a date, then it remains clear.
How do I flip a column of numbers, to reverse the order.
I have a small pasted image in a spreadsheet. Every person/pc that uses this
sheets views the pasted image right-side-up, no exceptions. Almost every
person that prints the sheet have no problems, however, a few people print
the sheet and just the pasted image prints up-side-down.......?????? Has
anyone experienced this and found how to remedy?
Thanks, Mel
I am having trouble creating a similar spreadsheet to Excelisfun video #712. The only difference between mine and his, is that I have 3 blanks between the data sets. Can someone help?
http://www.youtube.com/user/ExcelIsF...22/Po35KC2ODNw
