Search results

Awesome, and thanks for your help!!!

Hmm... interesting as to why that happened. I went back and changed the format to numbers. Sorry about that, and I truly appreciate your help. :)

Ach... my bad! Sorry forgot to upload it. :(

I have a list: multi column and multi rows in an excel sheet. The first column is TIME in seconds with a unique number on each line. The last column is called STEP (as a number from zero and up). Each STEP has a different number of rows (time at a data point which varies) that corresponds to a...

Hey @GraH - Guido -- that does it!! Many thanks! -Dave

Hello all, This one should be easy, yet for some reason I get the feeling I'm overthinking it and would love to get your thoughts. Here is what I'm trying to accomplish. On the attached spreadsheet, I would like the answer in B11 to inform the cell C11. However, I’m trying to write ranges...

@Peter Bartholomew Thanks! I appreciate your effort. You Rock!

Hello All, I could use a hand with building a formula. I'm teetering between two distinct IF statement, or perhaps a nested IF (?). Here is the issue. We are given the sheet with product cost and MSRP. Our prices are 40% margin above cost (cell/0.6), which gives us our web retail price. We...

Hey GraH, Yeah... I gotta admit it was the end result of a hurried conversation of which I wrote down what the powers that be are looking for. I'll take a peek at your suggestion. Many thanks! -Dave

Hello All, To make things easier attached is a spreadsheets with comment to help spell things out. In short here is what I'm looking to solve. We work with a product list that lists many columns, of which the key one are: wholesale, retail, our price and displayed. The our price and...

@Narayan and @Chihiro Awesome and thank you!! -Dave

Hello All, I just started studying PowerPivot and for the most part can grasp the data modeling since it's similar to Access. The one question I have pertains to calendar (date) tables. The one thing I really don't understand is why do you need to create a separate calendar table in the first...

@Chihiro -- Thanks so much and to answer your question, no I have not read the article. I'll give it a glance when I have a moment. Thanks! -dave

Hello All, I thought this would be easy, yet I'm missing something. The attached file uses a table and my understanding is the Excel table formula structure are a little different. What I'd like to accomplish is, if either cells G2 or H2 are blank then leave cell I2 blank. I know there is...

Hah!! Nice One! ;) All the best, Dave

@Dave @David Evans-- awesome man!!! And thanks.... So does this mean you're like "The Edge" of Excel? Sorry... couldn't resist. :)

Hey Everyone, I'd like to get some outside thoughts on how to calculate which zip code gets the most business. Some of the key things I'm trying to figure out are in the bullet list below and in case it helps I put my hunch/ suggestion in parenthesis. Love to hear anyone's thoughts! * Where...

@Narayan and @Bosco... Many thanks! I'll have a go and see how things work. I appreciate your efforts. :)

Ok. So hopefully someone has a solution to this one. Please see my excel file for more information. I have a list that I input. Laps, Sit Ups, Jumps, Push Up, Stretch….. I tell my list how many minutes I want to work out in Total and what percentage of time I want to spend on each exercise...

Hey AVK, Sweet! I like it... many thanks! -Dave

Hey Khalid-- many thanks!!!

Hey Luke... great stuff! Question- what does the 1* portion of the formula do? I've never seen that before. Best, Dave

Hey Everyone, I'm working with a formula and am curious to see if there is a more efficient (read: streamlined) way of doing it. Columns P and Q were extracted from information in column G. The goal is to look at the values in column G, which are manually input from people and separate them...

Hi Bob, Sure. Please allow me to clarify. With the helper column we just needed the first number. Anything after the X was discounted/ not relevant on the grand scheme. So for example when the formula was used it just returned the first number in the measurement of which we just sorted by...

Hi Everyone, The other day this question came across my desk, and even though I was able to create a plausible solution I can't help but to think there might be a better (more efficient) way, so I figured asking the collective might help. Here is the situation. Imagine a column that lists a...