Search results

I added a new thread and got a solution for this. Thanks again for the help!!!

Perfect! Thank you!

I have been working on the formula on the attached file, template tab cell Q5. The formula is working but it references month numbers in row 5 and I would like it to reference "X"s instead. The idea is for users to enter an "X" for the columns that apply. I could convert the "X"s to numbers...

Using some tips from everyone I was able to create a formula that is working. There is one improvement I would like to make. Currently the formula will work if month numbers are entered in row 5. This is the row users will enter data. They will be entering "X"s. If I don't get a a solution...

I'll try that. Thanks!!!

If I change the Q28 reference to any other cell the formula doesn't work. This is problematic for converting the formula from this example to my actual spreadsheet. Maybe if you can explain what that reference is doing in the formula. Thanks in advance!

Question on the sumproduct formula. You have a reference to cell Q28 but there is nothing in cell Q28. Should that be a reference to a different cell? Thanks in advance!

I could probably get away with using an array formula. It is not possible to export the data from my system without using cross-tab format. I need to use this particular system for this solution.

Thanks for your response.

I'm running Office 365. This would need to be compatible for Excel 2017. I'm unable to change the data format due to the large amount of data I have and system constraints. I also want to stay away from array formulas because this spreadsheet will be used for a large user population and they...

I attached additional detail on this file.

I need help creating a formula that will take into account criteria on a different tab. I have an example on the attached file. Any help would be appreciated. Thanks in advance!!!

Thanks! I like the tip in the document about adding a menu option to the Quick Access Toolbar. I'm going to go with that option.

I use an Excel Add-in that drops off the menu every time I close Excel. It is very annoying. I would like to create a macro that will add the add-in automatically when I start Excel. Specially it drops the com add-in. The Record Macro doesn't capture the steps of adding the add-in. Any help...

Great tip!

We found the issue, it was in a data validation cell. Thanks!

I am a proficient Excel user. I even teach Excel classes. I have a very large Excel template I am using at my company that many people use and in the process of creating a new version a phantom link appeared. I call it a phantom link because I did not copy data from anywhere into this file...

I'm creating a report template that will be used by many people. So it has to be easy to use. It is a large file. There are 8 data tabs where the data is the same but different time frames. I created one report template with formulas to pull in the data from the data tabs and create...

I'm looking for a method to create sum formulas dynamically. I'm creating a report where there will be a data tab and then users will be setting the report tab themselves. They want the flexibility to group information as they wish. But I want to make it as user friendly as possible. And one...

I'm being needy today. I have another question on the same spreadsheet I'm working on. I want to calculate Rank but I want it to calculate separately for each Sub. On my example file I have the reference range for the entire data table which I need but somehow I need to add a piece that takes...

Thanks! Sometimes array formulas are a problem to use.

I have another tricky formula I need help with. I have attached an example. I'm trying to solve for a total in cell G11. It needs to sum the locations listed in range G7..G9 for the Sub# in cell G5. It is the multiple locations as a criteria that is giving me trouble. Note: normally I would...

Thanks Luke M! This seems to be doing the trick! I always say anything can be done in Excel but I'm still always amazed when I see it.