Recent content by mediatx

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