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
Hi,
I have a list of people who download music, it shows their name in column A, then the number of songs downloaded in B.
They can appear in the list many times and can download songs once or many times.
I would like to count the number of times a spedific person downloads more than X songs.
Ive gone mad with lookups and if formulas and need some help.
I just want to say for person "joe blogs" and X = 10 it will tell me how many times Joe downloaded 10 or more songs.
Thanks.
Just This Video For Fun
http://www.youtube.com/watch?v=0VvjrldlqI0
Hi All,
I am trying to use If condition to find which one is the max time however i am not able to do it.Below is the example
"Login Time
IST" Actual Login Time Discrepancy
23:45 23:53
18:15 18:35
18:15 18:13
19:15 19:14
18:15 18:15
In discrepancy i need to check if actual login time is more time than login time IST then it should subtract actual login time from login time IST or else it should display login time IST .
Note: Actual Login Time is in Time format.
I have the following code that runs a timer which is displayed in a form. I want the timer to go past 24 hours. I have tried putting the format as "[hh]:mm:ss" but when I do this then the hours disappear and the timer starts at 8 minutes for some reason regardless of what the time in cell b6 is.
The time saved in cell b6 is the time the race starts.
Code:
Sub RClock1()
Watch = Now - Sheets("Timing Sheet").Range("B6")
UserForm1.RaceClock1.Text = Format(Watch, "hh:mm:ss")
NextTick = Now + TimeValue("00:00:01")
Application.OnTime NextTick, "RClock1"
End Sub
Thanks for your help
Hi All,
I am trying to create a formula that will count how many times a non-zero value appears three consecutive times. For example, the formula should return "4" in the following example:
Cells B1:P1 contain the following values: 111011111100111
The first string of "111" values count as 1 instance + the next string of six "111" values count as 2 instances because we have back to back "111"s + the last set of "111" values count as 1 instance = 4
Handling the string of six consecutive "1" values seems to be the biggest challenge.
Would appreciate any guidance! Thanks in advance.
I need to find out how many times an excel workbook is accessed to determine
if workbook is being used by the audience it was desgned for. Is there a way
to count how many times a workbook is opened. Also how many times each tab
has been printed.
Hi everyone,
geting a bit stuped on this but i think its relativly easy?
i hope.
ok so lets say this formula is in cell E15 and i want it to look to cell A1 as the if:
so I want it to do this:
if cell a1 = 5 then e15 = cell e20 however if cell a1 = 6 then cell e15 = cell f7 however if cell a1 = 9 then cell e15 = another cell say h7 and so on for as many times as i need (max 20) anyidea how this can be done?
tony
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
