Search results

Also, although this works, the complete file has serveral thousands of lines where the data has to be extracted, so it's not that fast. Does anybody have a suggestion how i can make this go faster? Thank you

Hey Luke, Thanks for the solution, it works now :) I would just like to ask why? I don't understand why, by multiplying, you can put conditions. Thanks

https://docs.google.com/file/d/0B0naOkYo4pCmUUUxcmdKUnp2NE0/edit?usp=sharing Ok, so here is an adapted version of the file. Date comes in the extracted tab. This is linked with the date to calculations tab. The test tab is being used at the moment to try and get everything done without...

Hello, I might have a bit of a difficult one here :/ i am looking for a way to exlude certain rows when i am doing an array lookup. At the moment i am using the following formula: {=IF(ROWS(A$5:A5)>$B$2;"";INDEX('Testing Changed...

Fantastic, thanks guys :)

Hi, the situation is as follows. In column A, i have a list of dates, spread over a year. In column B, i have a list of numbers. How can i find the highest number per month, in such a way that the formula keeps working year after year, and taking into account that sumtimes the highest...

Hey :) Just wanted to let you guys know that i used the following formula in the first column (in cell A15) =IF(AND(A14<>"";A14<$D$1);IF(A15="";$D$1;A15);"") Then dragged this down for about 100 cells so that it would grow each time there is a new time stamp. Sincerely

Appearantly, if you put anything else in any other cell after changing the date, then it works. So it seems to be a matter of refresh. But is there any way to force the refresh after the date is changed?

Ok, basicly this is what i am trying to do: https://docs.google.com/file/d/0B0naOkYo4pCmNERlVVYzV3ZoQ0k/edit?usp=sharing now, if you change the date, the list on the left should compare to see if the date is higher then the previous one, and if so, take a stamp of it. The way it works now...

Hi, I was looking for a way to have a growing list where a new count was added everytime that the date changes. If i remember correctly chandoo has a tutorial about how to do something similar, but i can't seem to find it. I have a report that's updated on a irregular base, and i would like...

I think, Indian, that if we use your method, that the only thing i need is a way to copy data from a row where a date is filled in to the next tab. So in other words, when a date is filled in the main tab, then it would be added to a table in Executed Work. And if the date is empty, then it...

https://docs.google.com/file/d/0B0naOkYo4pCmUHZiSktGZHdFR28/edit?usp=sharing Explanation is as follows: Data is imported into the Main Data tab. This happens on a regular base (weekly) When the data is imported, a comparison of column equipment ID and Service is made between the main data...

Hi, The situation is as follows. In sheet one, you have a huge spreadsheet containing all the data. Amongst that is kolom D and J which are important for this question. In sheet two, you have an other spreadsheet, with koloms B and E containing the same type of data as the ones in sheet one...

Hello everybody. I was wondering if it would be possible, through the use of forms, to make it so that a group of people could fill in data in certain coloms of a read only file. The idea is that there is a list that ppl could open as read only, and that if they are part of a certain group...

Thnx for the complement Hui, it's the first thing i ever made in excel, so i'm not sure about possible incompatibility mistakes. :) Guess i can't do anything but wait :/

On the tab Dashboard, Top right, you have the 5 buttons, they interact with the graph underneath it. When i try it on different computers, sometimes it only shows 2 or 3 of the 5 graphs, sometimes it shows none. I have temporarely included a droplist to the right of it, to see if it had...

this should be it https://docs.google.com/file/d/0B0naOkYo4pCmZ2k3aE1rb2gyODQ/edit?usp=sharing hope it works

If you give me a couple of minutes, i'll just remove sensitive data, and i'll post it Thnx for the help already hui

Hi, I have been using the explanation provided in http://chandoo.org/wp/2011/03/16/analytical-charts-tutorial/ to create a selectable switch chart ( 5 buttons, 5 charts) Now, this in itself works perfectly. On my computer. But when i open it up on other computers ( they do have 2007...

Hi, is there a way to make excel select and show a certain image depending on the result of a formula. What i am trying to do is, depending on how much the end percentage is, have excel show 1 image out of a selection of 8. The plan would be to have a sort of bar graph consisting out of...

Hui, thanks. this is fantastic info. Can i just ask what the [<1] does? This is just so i know what else i can use it for. Thanks again

Thanks a lot. :)

Hi, first time poster here. Let me say first of all that i have learned everything i know about excel from you guys. I started using excel professionally about 2 months ago, and up to that point i only used basic formulas and nothing more. Things advanced a bit since then :) Now for the...