Search results

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...

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"...

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...

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...

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...

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...

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...

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...

Hi everyone, I searched, tried and failed, a hundred times, several hours now... Am I that blind? I have a service schedule from (C2)09:00 - (D2)17:00 A taskplan starting with a Startdate in A9 entered as 29.04.2010 09:00:00 Cell A10 needs to be the Enddate, calculated based on a value...

Hi Champs I might be completely blind after working days on the same sheet to create an assessment solution based on excel. Now coming to the "optical" part, I dont find a way to color text in sheet2!B2 based on a value in sheet1!C2 (Yes, No, Partially). If Sheet1!C2 is Yes, then i want...