Search results

That was it exactly, thanks for the tip. I've been using that dot syntax in my table names for six years with no problem. So it makes perfect sense that Microsoft would change it in 2020.

Thanks for the response. I'm not sure I understand what you mean by "fullstop" in the table. What is that and how can I fix it? I even pulled up one of my older spreadsheets, created a new tab, and tried to add some stuff up and wasn't getting a drop down on the field name.

Hi everyone, It's been awhile since I've created a new spreadsheet, so I don't know if my problem is because of an update I didn't know about of if there's another reason for it. I use single cell arrays a lot and until now they've been reliable. When I start a formula, a drop down will...

Ok, thanks.

Hi everyone, I was hoping to tap into the vast knowledge base here in preparing me to make a proposal. I'm trying to get everyone where I work to start structuring their files database-style; flat-file tables. Before I get to my question, I want to give a little background on how I do stuff...

Kevin, One thing you can do to help yourself is segregate your data from your calculations. Also, when you have your data in a matrix like you do it can make finding what you want difficult because there are often intermediate steps in getting what you want. Learning how to structure your...

Thank you, I appreciate it.

I tried that. The gridlines wouldn't even display when I changed the cell color to dark. That's when I started to wonder if it's a cell issue and not a border issue.

Hi everyone, I'm developing a custom template and I've run into a formatting issue I'm hoping someone here has dealt with and could offer some help. I'm creating a sheet that I want to be dark, e.g. "night time." It's a pretty dark shade of grey. I'm also the kind of user who likes to toggle...

I think this is what you were trying to do.

Thank you, I appreciate the quick response. You did what I was trying to do but I was unable to get it to work.

Hello everyone, I have a problem I’ve not been able to solve and so I’m hoping someone here can assist. What I’m trying to do is isolate records by month and then perform a VLOOKUP or a INDEX+MATCH, or some kind of look up, you get the idea. I’ve got an inventory of widgets. I’m using a...

I don't know if anybody cares, but I figured out how to get it aligned. When I was having the problem, in the Home tab I had all my numbers right aligned. I de-selected the right alignment so that there was no alignment in the cell and it gave me the exact effect I was looking for. Weird.

Thanks, Hui. I'll give that a try.

Hello everyone, I'm trying to use a custom number format with arrow symbols to represent a positive / negative change. In addition, I'm using color codes. My problem is the arrows are not aligning the way I would like. I would like the arrows left justified so that an imaginary vertical line...

Ok, I appreciate all the input. Thanks. I think my next project is to learn up some VBA to try and work around the volatile functions.

I have one TODAY function and there are some things downstream from that. I also use INDIRECT and OFFSET, but only for chart ranges, with nothing downstream from those. I try to use INDEX instead of OFFSET when I can, too. I think my data are in database format. They are all flat file...

Ok, I think that makes sense. Basically what you're saying is the complexity of a formula and the number of complex formulas in a workbook doesn't really matter. The only thing that matters is keeping the number of records to a minimum, is that right? Eventually, it's in my plans to have a...

Greetings Everyone, I've been working on a pretty big dashboard and received a lot of help from here, so first of all I want to say thanks. My question today choosing between two options, the goal of which is to optimize speed and use fewer resources. My dashboard has a lot of date look ups...

I'm using Excel 2013 and Excel 2016 and it's changing the formatting. This has happened with other charts, too. I figure using VBA ought to fix it, but I don't know any VBA. Either way, I appreciate your help. Thanks!

I had colored each column differently. The left column I had formatted as blue, the middle as grey, and the right as green. The formatting disappears once the combo box is used and different options are selected. All the columns revert to the default blue. Even if I go back to combo box's...

Thanks Narayan, I appreciate it. But how come the chart itself does not keep its formatting when a new item is selected from the combo box?

Hello everyone, I'm having a charting problem and I'm hoping somebody is able to assist. I'm using a combo box to select a range that populates a column chart, but I'm not having success in getting it to work. I've looked at the Chandoo tutorial and other ones I've found on the internet, but...

Thanks, Narayan. That is exactly what I was trying to do. I felt like it should not have been difficult, but for some reason I could not get it to work and I must have tried every conceivable method for multivariable look ups. In that vein, could you tell me why the SUMPRODUCT is returning...

My preference is to perform these calculations over an entire array (to prevent tampering and accidentally deleting), but sometimes it seems like the only way I can get the function to work correctly is by doing a single-cell array and then dragging that formula down. For whatever reason, the...