Search results

@Nick M - that worked perfectly, thank you! @Luke M - I wasn't aware of that feature. I tried it however I have not been able to get it to work in applying the highlighting to columns. I must be doing something wrong.

Hello, I have a spreadsheet where the data is associated in pairs...so 2 columns at a time. For example: A B C D E F Old Date New Date Old Time Stamp New Time Stamp Old Cost New Cost Is there a way to highlight 2 columns at...

Montrey and sheter, Thank you both for your assistance. That worked perfectly! I've never used Custom formatting so I'll have to keep that in mind for the future. Thanks again, Leimst

Sheter, Perhaps I'm doing something wrong but when I apply that format Excel is adding a decimal points and the 10 zeroes after that. My "missing" zeroes are leading zeroes so consequently I need them at the front of the number sequence. Any thoughts? Leimst

Hello, Is there a concise formula that would look at the number of digits in a number and insert the necessary number of zeroes required to bring the number of digits up to a certain length. An example would be that I have a column of what should be 10 digits numbers. However, some of the...

That's it!!! Thank you very much Faseeh!!! Have a great day, Leimst

Faseeh, That is true but I believe that I have seen a technique that very simply and quickly produces a separate tab for each one of the managers. So in essence, if I had 10 managers, it would produce 10 tabs...one for each manager. Thanks, Leimst

Hello, I have a pivot table with sales information by manager. It seems like I recall that Excel has the ability to generate a separate pivot for each one of the managers at the touch of a button which results in additional tabs in the workbook that would be labled by manager. Am I making this...

Kaushik, Thank you very much for your help and I apologize for the delay in getting back to you as I was pulled away for another project. This works great and after examining your formula I believe it to be comparable to a VLOOKUP command? Which VLOOUP (Index(Match(x)) is executed is...

Hello, I have combed through search results for combining 2 lists but I'm not seeing any examples where 2 separate lists are combined and duplicates removed. I was hoping for a formula that would eliminate the need for someone unfamiliar with Excel to manually combine the lists and remove the...

Good Afternoon All, I have 2 lists of names, each on it's own tab. Some names are on both lists while other names are only on one of the lists. I would like a formula that would look at each of the lists and return a cumulative list of names with no duplicates. Any help would be greatly...

Hello, Does anyone know of a good way to share PivotCharts with Sliders to others who do not have PowerPivot installed? Thanks for any help! Leimst

I have recreated the scenario in a new spreadsheet and cannot replicate the issue...I am consistently getting the result of 3 as Luke and SirJB7 have experienced. It is still occurring in my original spreadsheet though so I'm going to clear it out and start over. Thanks for the help! Leimst

I have shuffled the numbers around while experimenting with this. Perhaps the result of 4 it was showing was from a previous configuration of the data? I would think that it would recalculate in real time though as I made changes? I am not in Manual calc mode. Leimst

I'm getting Countif($A$2:$A$15,$A$2:$A$15) = 4 and {Countif($A$2:$A$15,$A$2:$A$15)} = 3 on my spreadsheet. However, when I select the Countif($A$2:$A$15,$A$2:$A$15) cell and hit the F2 key and then the F9 key and click on the checkmark in the formula bar it returns 3 just like the Array formula...

Sorry about that...yes, it should read Countif($A$2:$A$15,$A$2:$A$15).

Thank you both and that did it! I wasn't using the F2 key so that is handy to know as well. I was actually placing my cursor up in the formual bar and then pressing F9 and clicking on the Checkmark which apparently converts it to display the results. I now see that Control Z reverts it back...

Hello, As an example, if I have the following data in A2:A15, 65 54 25 36 59 36 12 65 84 87 65 36 36 25 If I use Countif($A$2:$A$15) I get the result of 4 but if I execute the Countif as an Array formula, I get 3 as a result. Can anyone explain why this is the case? Thanks for...

Hello, Is there a keystroke I can use to return a cell's display to the original formuala after pressing F9 and getting Excel to show me the results of the formula? After hitting F9, I've not been able to figure out how to revert back to be able to view my formula once again. Thanks in...

Unfortunately not. I've been instructed to let the users see the results returned by the formula columns based on the user's input which drives the formula results. That way they are able to see that they do not need to fill out those columns. I am also dealing with a broad spectrum of Excel...

Hello, I've tried enabling all of the "Allow all users of this worksheet to:" options when protecting a sheet but it still disables the "table" when I protect the sheet. What I'm trying to do is set up a form of sorts where the table expands as users provide input. Otherwise, I don't know...

Select locked cells, Select unlocked cells, Sort, and Use AutoFilter.

Hello, I inserted a table in excel so that subsequent rows carry the formulas with them. However, when I password protect the sheet the table no longer behaves as a table and the little blue triangle in the last row and farthest to the right column no longer appears. Is it not possible to...

Yes, that's it!!! Thank you! I'm going to copy this to where I can easily find and continually refer to it. Excellent explanation. Thanks again! Leimst

Luke,somewhere along the line I ran across a link where you did a great job of explaining array formulas. Could you possibly send that to me please? I'm still trying to get a grasp on how they work. Thanks!! Leimst