Search results

Thanks for the second set of eyes Luke M. I couldn't see the forest for the trees.

Hi Luke M, First, thank you for your help. Second, I just realized that the file I uploaded included a link to another file and therefore did not work correctly. I have corrected that mistake and have uploaded a new file here. There are 2 worksheets. One is Planned Only and the conditional...

Good Morning Forum, I have a Gantt schedule where I have a drop down list to select between Actual and Planned for the start, duration, and finish dates. Right now my conditional formatting formulas are working as far as coming up with the correct number of days in the schedule adjusting for...

Thanks Narayan. This is exactly what I was looking for, but was unfamiliar with what SUMPRODUCT was for.

Hi Forum, I have a grid of Monday thru Friday for the columns and a criteria column for Cost Type and then there are several rows of cost by cost type (see uploaded example file). I need to know the total sum in the entire grid for each Cost Type. So far, the best way to accomplish this I come...

Hi wudixin96, Thanks for the solution to my problem. I'm trying to figure out what the formula does. Could you explain what is happening in this section of the formula: INDEX($A$2:$F$2,,SMALL(IF($B3:$F3=$G3,COLUMN($B:$F)),COLUMN(B$3))

Hi Forum, In the uploaded file I have set up a bid analysis to determine the low bidder for each bid item. I am using the MIN function to determine the low bid and I am using Index and Match to pull the low bidder name. If there are duplicate low bids, I am using Conditional Formatting for...

Hui, Thanks for pointing me in the right direction. I found Group where you indicated and it does just what I wanted to do. Jon

Hi Everyone, I can't seem to find any information to the following. After creating 6 to 9 shapes and layering them to make up one visually pleasing KPI data widget for a dashboard, is there a simple way of copying that widget in order to have several of them as a header for your dashboard...

Thanks Narayan. This is one of the reasons that Chandoo is a great forum. I was looking for a more in-depth explanation of how to do layering with shapes for use in fancying up a dashboard when I did a search on this forum and found your two postings about the article you mentioned. There was a...

Hi Narayan, This does what I wanted to do. Thanks for the help - much appreciated.

Hi Nebu, Thanks for your reply. I am using Excel 2010 and have used slicers. I was hoping that someone could tell me why this macro isn't performing in my example. I'm at the just beginning level on macros and I'm sure that the changes that I made in the macro to adjust for my spreadsheet are...

Hey Guys, In my efforts to find a way to use drop down lists to filter a pivot table report, I found the following in an archive that indicated that it would solve the problem: Question Now that I'm using the function GETPIVOTDATA, creating reports the way I want them to look is much easier...

Thanks for the explanation about the formula Luke. I wasn't sure that Excel could do this and I'm really glad to find out that it can. Again, thanks to you and Narayan for you help

Thanks Narayan and Luke for helping with this. Luke, could you tell me in your formula what determines the day of the week (Wednesday in this case) and the week of the month (3rd week in this case) so that if I want to change the day to Tuesday and the week to the 4th week for instance?

Hi Forum, Is there a formula that will return the date of the 3rd wednesday of the current month?

Hi bobhc, Thanks for the explanation.

Hi all, Is there an advantage to converting original raw data to a table before creating a pivot table? Are there any reasons not to? Thanks.

Update. In cell R1, I entered Week 1. In cell S1 I entered =LEFT(R1,5)&RIGHT(R1,1)+1. I then copied the formula in cell S1 and pasted it into cells T1 and U1. The end result was that in Cell R1 thru Cell U1 I got Week 1, Week 2, Week 3 and Week 4. Thanks to everyone for your help.

Thanks Sajan for your solution.

Thanks Mr. Mahesh for the formula and the explanation on how it works.

Thanks bobhc, but is there a formula that will accomplish the same?

Thanks Mahesh, but what I am trying to do is in cell A1 I enter Week 1 and in cell B1 I entered =A1+1 expecting to get Week 2 but got #Value!

I am looking for a formula that will allow me to put "Week 1" in a column header cell so that the other column header cells will be "Week 2", "Week 3", etc..... Thanks

Thanks Sam. I never would have thought to look there.