Search results

thanks for taking the time to respond. I am getting an error on Val, does Need to be declared? Also: I am working with two worksheets, however, the corresponding variables are declared. Any hint?

Hi Guys I got two fields in different Sheets. Sheet1.L2 contains Number & Text (0 Days; 1 Day; 2 Days; 21 Days;...) The Reference Cell (ExecutionDays) only numbers I Need to compare the two cells which is easy using =--LEFT(A1;FIND(" ";A1)-1) to only get the number value from Sheet1.A1. As I...

Excellent! Thanks for that formula, it really does the Job and refreshed my brain... :) Time to drop that §""!?% sheet for today.

Hi Guys I am in Need to plan travel time as average based on an amount of days spending onsite at the customer. In Detail: For every <=40 hours I Need write 4 hours in a separate cell. So when someone spends 24 hours at the customer (less than a week) I want the fomula to write "4"...

ok, got it done!!!! :) I inserted a new column in Sheet1 stripping of the product with a huge nestedIF, and then use index & match to get the price from the sheet2. what a formula!!!! Thanks anyway, that really helped me getting into the right mood to think how it could be done!

would it be possible to use FIND within the MATCH function? If so I think I could get the thing working with INDEX Any idea?

Thanks for your help and even spending time on it. The two problems i got: 1) I can not influence how the text is entered in "labor task" 2) I am using powerpivot to cleanup from several sources and merge, so i cant use transpose So I hoped there is a way to create an arry taking all items...

not sure where I can upload here, but i put it on http://www.4shared.com/file/sB3VQaV6/Sample.html In Sheet1 in c1-C4 I need the prices from sheet2 So I thought it should be possible to look in Sheet2!A2:A6 if there is a match from Sheet1!A2:A4 and get the corresponding price displayed in...

Hello Everyone hopefully someone is able and willing to help me how to solve the following problem. NO vb is possible, only formulas can be used. Within sheet1 in column "labor" is a field with contents in various formats and lenghts like: [Table1!A1 = Column:Labor] PPTM quicksearch...

"i like" - yes, was absolutely in panic... you might know that if you ever had to do a H1 Report within 2 days time (from scratch!)

are you kidding me? that´s it? ok... i feel ashamed now - lost my focus in panic... THANKS!

sorry for the dramatic intro, but I am finalizing my H1 report and found some errors that I need to validate. To find the errors i need to validate existance of a specific number. To find it, I have two colums (A1 = Tool1Data | B1 = Tool2Data) How can I find out what data in "Tool1Data" are...

Luke, thanks! That was what my brain actually lost while looking for some fancy stuff, I really forgot countif! :) Thanks so much!

Hi Champs I have a table, coming from shrepoint (which I cant change). The Data contain trainings information from some staff members and I need to display them as Bar Chart or similar (better idea?). Problem: I get the data as follows: Name Training1 Training 2 ... Donald...

Hi Champs Can someone help me or point me into the right direction? I am creating an addon and need to achieve the following: When the Application / Template is opened, it should check if the latest entry in the clipboard is an *.xsl or *.xlsx File, if that is the case, a C# Module within...

Hello Hui Thanks for the advice, unfortunately I need local copies (offline usage) and using the standard template folder is no option. The "internal" was a sample. It could be "dashboards" too. So what I need to achieve is having an "icon" as with the other items provided when going to...

Hi Guys I created a template without any fancy stuff, no development, no nothing. I want to make this template available for some more users and deploy it to them. How can I make the template appear in a new category (home --> Internal). I do not want that template appear in "My...

Chandoo, I only can say: BIG THANKS - you saved my day!

Hello Chandoo, thanks for taking the time and answering, partially, it seems to work BUT there seem to be an issue 11/29/2010 9:00:00 AM returns 11.05.2012 8/23/2010 9:00:00 AM returns 08.11.2011 so the format looks great, but for any reason the months values are now days and the day...

Hello Everyone From an excel data query, I receive thousands of rows containing dates in various formats. The dates imported are useless for me as I receive following date syntax: 03.01.2010 (my default format = dd.mm.yyyy) 1/3/2010 9:00:00 AM (m/d/yyyy ...) 01/03/2010 9:00:00 AM...

Hi Guys I am in need to create an Excel (2010) based sheet to enter and track individual commitments of ressources. I want one workbook per ressource, another that takes these data to merge the group goals (1 or more persons) and another to track the group goals to team goals (1 or more...

Hi Psionic, thanks for the hint, but that wont help, with users in different regions in this case, however, I have this sorted by converting the content to a table and then back to a range, bring the same effect as it was needed.

Sorry for shouting around, but I am working my ass of for weeks now to finalize a template for a project, had all running and now face some issues when testing different Computer Locales. Problem: By inserting a formula in Excel by Macro, this formula gets not "adopted" when the locale...

Hey Chandoo this is magic and I even dont understand the formula, however, it works for weekends but does not consider the service schedule on weekdays. Adding 9 hours in A11 results in same endday at 18:00 - did I do something wrong? Please notice that I might be too much a newby and use some...

@oldchippy, exactly thats what I need, hoewever, not only for weekends, but worktime in general (public holidays is not that relevant). So if I have office time from 09:00 to 17:00 and have a task on Monday starting on 16:00 lasting 2 hours, it means, it finishes on the next workday (tuesday...