Search results

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

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

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

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

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

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

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

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

Hey Everyone... Question... trying to figure out how to create the following format for a date series. 01.01.2016 01.02.2016 01.03.2016 01.04.2016 etc.. I've played around with the date formats with no luck... not sure what custom format to try and create. Curious to hear your thoughts...

Hi Everyone, Quick question.... How, or can you, create a chart using the time slicer to overlay two periods, like the last quarter of 2013, 2014? Thanks! -DM

Hey Everyone, Question... from time to time I get some data imported (external source) as a number, when in reality it's a representing a date. Phrased differently, the data imports without the proper format. For example, after the import is complete the cell value is 20151231. I'd like to...

Hello All, Question about Pivot Tables/ Pivot Charts. I have an excel report that covers two weeks of data (hours charged at a project level)and have created/ converted this to a Pivot table. Would like to insert a Pivot chart that will identify the hours comparison from one week vs. the...

Hey Everyone... I'm a little stumped and can use a hand. I have an excel report that covers two weeks of data (hours charged at a project level). It's been converted to a Pivot table. Like to insert a Pivot chart that will identify the hours comparison from one week vs. the next. Make sense...

Hi Everyone, Question for you. I'm trying to figure out how long a person worked at a company to the year and month. For example, they were employed from XX/XX/XXXX date through XX/XX/XXXX date-- how many years and months were they employed- displayed like X years and Y Months, say 7 years...

Hi Everyone, I am trying to figure out a way to include an "average" line in a pivot chart and have attached a generic file that I am using with a pivot table in a separate worksheet. This file has report data, which I am using to create the pivot table and am trying to show an average line in...

Hi Everyone, I am trying to figure out a way to include an "average" line in a pivot chart and have attached a generic file that I am using with a pivot table in a separate worksheet. This file has report data, which I am using to create the pivot table and am trying to show an average line in...

Hi Everyone... just had this question popped up and I'm thinking the best option is a macro. Love to hear your thoughts/ probable solutions, alternatives... please see italics. I have a project where 450 pictures are needed to be inserted into their own column, matched to a part number in...

Hi Everyone, One of my clients asked for some help and I'm stuck. I'm betting the Index (or Hlookup nested with IF) formula will be needed to solve it but have no clue, so here goes. Pardon if I'm a little long winded. If you look at the attached file, focus on row 10 since it will give...

Hi Everyone.... Not sure if this is possible, but just like to know your thoughts. I'm currently using Excel 2010 and know you can do this in other, older versions. I would like to open a new instance of Excel every time I open up a saved Excel document. For example: I open spreadsheet A...

Hi Everyone, This post may be a little premature, but figured I'd ask. One of the people I work with deals with Pivot Tables and need some help. Below is the email he sent; of which I cannot offer a solution since it, from my perspective, does not offer any real substance. Thought maybe some...

Hi Everyone, I got a question from a coworker, it's a little convoluted so I copied and pasted it verbatim. I'm thinking to solve this the formula should be a nested IF and SUMIF. Love to hear your thoughts. Please see below. --------- Trying to use some different functions. I want to...

Hi everyone. Question- is it possible to have the solver return more than one solution, without having to (consistently) change the constraints. For example: X + Y = 10 Current formula 5 + 5 = 10 Solver--> set cell to 10 (the formula answer) by changing X and Y. Constraints, X <=4, Y>=...

Hey Everyone.. Real quick I get questions from my co-workers since they've anointed me "the excel guy". Lucky. Me. Anyhow--- here is one sent to me... copied verbatim. Can interpret this a few ways... curious as to everyone else's thoughts. See below in italics Can you give me an idea...