Search results

https://docs.google.com/file/d/0B0naOkYo4pCmMlVKdEhidVdCTnc/edit?usp=sharing The column date contains the date as it is extracted. The column corr date is the date how it should become (automatically).

Quick question, i am doing an extraction of date's out of a txt file. now, after the extraction is done, i have a list of dates, but i notice that some of them are in european format, and some are in american format. So that makes it that it shows some dates as completed on 4th december...

Hey Jeffrey i hope the image in this link can shed some light on what i'm talking about. https://docs.google.com/file/d/0B0naOkYo4pCmQzRuZ0Z2aHB1Nms/edit?usp=sharing I just find it really weird that excel doesn't show the data correctly without having to recalculate it all. i tried to...

Hi everybody. I was just wondering if somebody would know why the option to calculate that is located at the bottom left of the screen (underneath the tabs, next to the word ready) sometimes is visible, and sometimes isn't. At this moment i have a pretty big calculation sheet, and when i...

Hi everybody, just a quick question. Does anybody know of a way that you could integrate a sort of selection of table in a formula? For example, you have a cell that goes from 1 to 5 and in a formula (for example =SUMIFS(Table1[ActualOpen];Table1[Request Service...

Hi Jef, i never really thanked you for your help. With this, i would like to :) Sincerely

My apologies, i was not aware what would be the correct location for my question. It will not happen again

Hey all, I'm doing a comparison now between the suggested formula from Narayan, and the following. I put an extra info square in containing what eachfirst letter of the equipment group that corresponds to in cells E1:F3; and then i put the following code...

Hello again everybody; I am trying to achieve the following. I have a row with unique id's. In a column next to that row i would like to have a formula that automatically puts a 1 if the id isn't found in any of the tabs that contain data.( i have included an example, because I know that it...

Hui, seriously, You scare me sometimes :) Thank you

Hi everybody, i seem to have got stuck on a date calculation. ok, so i have 1 column with date, and another column with a recurrence indicator in the form of for example 6 M (6 months) or 80 D (80 days) or 7 W (7 weeks). These numbers varies. Now, what i need to get is a column with the...

Excellent :) Thnx again Narayan

https://docs.google.com/file/d/0B0naOkYo4pCmck9GZTJVQkFjNGM/edit?usp=sharing So what the point is that i am trying to reach, is that by selecting one of the checkboxes, and a plant that the column requestnumber is shown if it meets the 2 criteria's (so C3 and F3). I need to have a list with...

Hi, i've been trying to use the guidelines showed here http://chandoo.org/wp/2010/11/02/multi-condition-lookup/ to do a filtering depending on 2 different criteria. But for some reason i keep getting the #value result, no matter which way i use. Is it that these different possibility's only...

Hi again. first off, thanks for trying to help me out, but i have come to the conclusion that there is not enough data to get the desired result. Which can also be seen as a good thing, because i think we have found a flaw in our system. Now we can work on improving it. Thanks again for...

Hi, i'm a bit stuck at the moment with a bit of a logical problem. https://docs.google.com/file/d/0B0naOkYo4pCmZkNtSHlEUnNWQk0/edit?usp=sharing Now, in the above file you see that i have a column with due date, a column with Last serviced, and a Column with interval. I'm looking for a way...

Thanks Hui

Hi, I was wondering if the following is possible. You have a list with conditional formatting with cells that changes the colors depending on any given parameter. Is it possible to have another list with different columns that get filled in with the data from the first list depending on the...

Hey, just a quick question. I have a column with due date, and a column with date submitted. I want to have the due date to stay white up till 90 days before it is due. Then it should go orange. If the date in the column submitted is filled in, and if the date that is filled in there is...

I think i got it to work :) Thanks guys

The thing is, does it also work with exclusions? The above example is to simplify it a bit, but in the actual spreadsheet i would have to give all the January's for example, but without CLN, CONSLT, E, MOD, PAINT, PAINT2 and REP, but with 30 other possibility's. That is why i think it would...

Hi, i was wondering if it was possible to do a countif of a column, ignoring the ones where in another column there is a parameter. A B JAN CLN JAN MOD FEB CLN MAR MOD DEC MOD MAR CLN FEB REP FEB MOD In the example above, when trying to count amount of JAN, without MOD, it would...

Thank you for explaining it for me Naray. Now it makes sense :)

Hey Narayan, Unfortunately the equipment id is not unique, but i think i could make an unique row by combining several rows. I will just insert an extra helper row, and try to work from there. Problem will be that they want to be able to filter on plants with exlusion of several services...