Search results

Thank you. I did the dates sheet completely wrong. It now has an extra step and I am unsure of how to correct. I now have two data sheets instead of one because I wanted to give the option of selection by course or month. Some sheets are hidden. But you can unhide easily. Thank you.

First I want to say thank you to Basavaraj K H for helping me with the first set of formulas. I did the second set by myself but it did not look nice, but it is ok since that sheet will be hidden. I am uploading spreadsheet here if someone can look and give me some suggestions or advice on...

Yes K2 is great.

Also, Thank you for your help. I really appreciate this.

Yes. I see that you added a unique column and the other column had each course with a number if they duplicated. This I understand and can repeat when I add more courses. Do I have to keep them grouped when I add? Can you explain why you created a Slab sheet? I am not understanding this one...

Here is the updated spreadsheet.

I have updated the spreadsheet and on the dashboard sheet I have put some ideas. Basically in my head I want to be able to pick a date or week or month and it will display all the courses for that time period and where they stand. Also I think this is called a slicer but am not sure. I also...

Hello! I have been searching for different places to learn excel. I read Chandoo's blog and today I really started getting into excel more. I am teaching myself as much as I can on different websites. I want to be great at this one day and hope to open up my own consulting business one day. But...

Hello All, I am very new to creating dashboards and am going online and trying to learn as much as possible. I am trying to create a dashboard that will show me information when I choose a date or an event. If I choose the date option then certain information will show or if I choose the event...

I have been searching this site and am unable to find an example or tutorial on how to create an excel form which takes the data and puts in a different worksheet. I will also need to have an email sent to me when the due date is about two months out. Can anyone guide me where I can find the...

Thank you. This worked perfectly and I figured out how to have it autofill. My apologies for being a little dense.

Thank you. That helped. If I may be of a bother, with this formula I have to enter ctrl+shift+enter in each cell. Is there a way that can be done automatically?

I have a spreadsheet that transfers information to another sheet. Unfortunately it is leaving empty rows. I have attached the spreadsheet. I am new to excel and am still learning. Thank you.