Search results for query: *

Yes, Skip, I know the odd numbers are causing the calculation issues. I'm seeking a formula to copy down down 10M+ rows in columns b & c that will accomplish the following: 1. For each line (before total line), the formula in columns b & c will return a variance of 0 in column d. 2. The total...

I have a column of numbers (see 'Qty' column on attached file) that need to be divided in half and the resulting values placed in columns b and c. I use the ROUND function in order to do the calculation. However, when the 'parts' are added together, the sum does not always add back up to the...

Skip - Per your request, here's a copy of my 2nd inquiry about adding 2nd Data Validation column in Google Sheet document. Thank you. (Same Excel worksheet attached before upload to Google Sheets.) --------------------------------- Hello again. In an 'ideal' world is there a way of doing the...

Hello again. In an 'ideal' world is there a way of doing the following 1 or 2 things? First, could there be a 2nd data validation column to the right of the 1st one that allows the user to input info provided that it's not the same info as the 1st DV? For example, let's say the 1st DV column...

No worries. Thank you, Skip, for being so responsive. And, Happy Holidays!

Skip, One question. Any thoughts on how to remove the 'error' message that appears on DV - "Invalid: Input must fall within specified range"? I thought there would be something in Google Sheets to remove message, but haven't found it yet. Again, thank you for feedback!

Thank you, Skip. Your solution works! Much appreciated!

I needed to create a listing that had a column with Data Validation (DV). Once someone selects from the column with DV, that selection is no longer 'available' for others to choose. This is accomplish using other formulas from a solution provided by a website (URL listed in the attached Excel...

Thank you, Skip. I'll see if I can make this work.

Skip, See updated file, Sheet2 and 'Chart 2' starting in row 29. I've added some clarity. Bars in chart must represent 'Actual' column. My wish is to add icon symbol to the data label. Or, as a 2nd choice, the icon symbol could be added to data table. The reason my preference is to add to...

Skip, If helpful, here's the link to the video about creating your own icon set and adding to chart as part of the data table. I'm hoping there's a solution that allows one to use the existing icon set already inside Excel. Link: http://www.myonlinetraininghub.com/excel-dashboard-course

Okay. Attached a file re: charting and whether or not icon set can be added to graph.http://files.engineering.com/getfile.aspx?folder=58052521-e475-4140-babc-6aee8e385c59&file=Charts_w_Cond_Format_Icons-TT.xlsx

Skip, Disregard file attached. Has nothing to do with this issue. Will create & send another file.

Hi, Skip, I did use separate CF for each radio icon. Also, thought I had attached zipped file with docs and re-attaching again. Let me know if you receive the zipped file this time. Thanks.http://files.engineering.com/getfile.aspx?folder=aa1f98d2-7794-40f1-ac1f-6e235377b671&file=Files.zip

Is there a way to include Microsoft Excel's conditional formatting icon set inside a chart -- as either part of the data label or attached to chart as part of the data table (or other solution)? I've not had success in doing so using Excel features on the ribbon. The closest I've come is an...

I have Excel cells that include conditional formatting (icon set) in a 'helper' column. These cells are linked to a report that's in PowerPoint *using Paste Special >> Paste Link Microsoft Excel Worksheet Object). It's been noticed that when converting the final report to a PDF before...

Thank you, Skip.

Yes, I know. How do I make it an absolute cell reference? I thought using named range work, but it does not appear to solve the issue.

In Excel, one can use absolute references. The cell with absolutes can be moved and the cell references do not change. Similarly, I was expecting the PPT image of Excel data to not change. When the blank columns (cells) were inserted in Excel, it looks as though the PPT image now referenced...

What needs to be read? - Axis titles, both x and y. Last sentence - Need to find another solution; I'm in the process of trying to get more space on the document to enlarge image. Thanks again, Skip, for your time.