shown

When you copy there is an option to copy as a picture. When choosing tat option it asks you if you would liek to copy as shown when printed. However when I choose this option it does not show me sheet as shown when printed. I have slicers that are not suppose to show when printed yet they do. Am...

I have a worksheet as ff: column A Column B Column C materials unit of measure quantity sorted on column A then SUBTOTALed on column C but after that -- only Column A & Column C were shown the column B is blank! is there a way to...

Hello, Is it possible to create all possible magic esquire 3x3 which total must be 14 using 0 to 8 numbers? Numbers can be used repeated Like example shown below...

I have one chart on a worksheet and I want to use VBA to adjust the values of the Series which are in the chart. There are four series shown in the Source Data info box for the chart. In addition there is a Category X axis label shown which has values also. I know that I can use, for...

Apologies for not knowing what this may be. I have the following table and am trying to figure out if excel is even capable of indexing some value. Each number on top has 2 categories. If the desired number chosen is 34, the result should be 30 and 40 for example. If 30 is chosen, the 10 and...

Hello, I have been searching the internet , but unable to find the answer... I have a sharepoint list which displays perfectly in Standard view, if i try and switch to Datasheet view , I just get a blank grid. I have asked colleagues to try and they get the normal excel/access grid format...

https://www.extendoffice.com/documents/excel/895-excel-sort-dynamic-data.html#a I've been trying to accomplish something in Excel for about a week. After many Google searches, I was led to the link shown above. Although the type of data shown in this link is different, it is essentially...

Hi All, I have a call costs spreadsheet that shows me call cost and call duration. How can I work out the cost per min of that call? I have duration in column G and cost in Column H Duration shown as xx:xx:xx Cost shown as £xx.xx Thanks all.

I have a macro that enables a simple Undo of a macro update of a sheet. After the macro is run the user is asked if they want to Undo the update. With 2016 I'm experiencing a problem shown in the image at https://www.screencast.com/t/AVZvslfnhFM which is also described below... If they say...

Good afternoon. I am seeking help with a tiered commission schedule that appears to deviate from everyone else. I have included a document here: https://drive.google.com/file/d/103b0w6uWLwOjTNbm9GGl_EkJMQ2ozcFt/view?usp=sharing The gross commission goes into C2. The Gross Totals has a...

Hi there, I'm trying to split a list of alpha numeric location references as shown in cell A1 into two distinct references that I require, as shown in cells B1 & C1. Can anyone assist? Any help would be grateful and I can tell my team off for not collecting the data properly in the first...

Hi All, I inherited a power point presentation that shows the average, minimum and maximum values from survey response question. I have the underlying Excel data but don't have the work of the person that calculated these things. The average is shown, including the confidence level. I'm not a...

I am stuck on an if statement formula. I hope someone can help. I have a list of fruit options in cell A1. I need a formula that will display the price of each fruit selected in cell b1. So If "Apples" Are selected from cell A1, the price that will be shown in B1 is 5 If "oranges" are...

Hi, How do you customize the display of a cell so ✓ -- is shown when the value is equal to 1 x -- is shown when the value is equal to 0 ~ -- is shown when the cell is blank or anyother value is entered

<tbody> I have an Excel sheet that calculates the positions of each country in a Group after placing the scores of each match for the 2018 World Soccer Cup in Russia. I have national flags corresponding to each country shown on the top of the 1st rectangle in the example and on column AC. The...

In excel, when you group: rows, data grouping levels are shown in a frame to the left of row numbers columns, data grouping levels are shown in a frame above column letters Is there a way to determine the width of the frame added to excels window?

Here's an example of what I need: ColumnA 1 2 3 4 6 7 8 10 15 16 Instead of manually hunting down the gaps, is there any way for me to get the above shown in a range, like this? 1 - 4 6 - 8 10 15 - 16 OR 1 - 4, 6 - 8, 10, 15 - 16 OR 1 - 4; 6 - 8; 10; 15 - 16 Thanks in advance!

Good Morning I hope someone can help. I have a file path as shown below. I need to remove the file name from the end leaving just the path as shown in the second line. The path and file names will change. C:\Users\keames1\Desktop\2 - Current DD + N R9\WCT Station 130 DDR9.xlsm <tbody>...

Happy New Year to everyone Hello, I am looking VBA solution, which count the constant occurrences of 1 only Data got in cells C6:P22, Results shown in R6 AF22 Sample Data...

I have a bar chart in Excel (2016) which derives its data from various places in a complicated spread sheet by the user selecting certain variables to show using a user form. If a set of data is shown or not is automated in excel by either collecting values, or setting all the values to 0. Also...