custom

https://1drv.ms/x/s!AvjBsEPEq12ngSB0nBRb6FOkOLJz?e=Jfo3wo Hey guys, I am trying to reduce my first table (where I have my data) into the desired output which shows information for unique values in Column C. In Power Query, I have Grouped By the first four columns. In the Group By popup menu...

In the spreadsheet below I have information that represents truckloads of steel. The different colors represent one individual load that has multiple shipper cities and / or multiple receiver cities. The loads however are on different Lines. They are identified by a unique Load ID (column B)...

I have created a custom tab on my ribbon through File > Options > Customize Ribbon and I have populated it most of the way with the Add button. I have added Solver and the Analysis Toolpak (Data Analysis button) addins to Excel and by default, Excel places them at the end of the Data tab on the...

Hello again everyone, I have two columns that I want to compare data and fill in a single cell with the SUM of one of those columns. The first column is K. The cells are populated from K2:K59. There are 7 different values randomly listed in this column: Custom, Small Industrial, Lighting...

I am trying to figure out how to create a custom format for numbers. Is it possible to do this? Positive Number Display (in color black) 145.00 Negative Number Display (in color red) (-145.00)

Hello all! I'm trying to set up a custom sort in VBA, but I ran into a problem. I'm establishing the array to use for the sort and it's fine except that one of the items being sorted is called "Invoice, Commercial" and it's affecting the sort, since there are commas separating the array...

Workbook has no tables and no protected sheets. Have created several custom views but excel does not successfully switch between them e.g. view “males only” works. Switch view to show people from e.g. certain town - also works but switch back to “males” only view and it fails - includes “females...

i am importing numbers in a classification hierarchy in the form of 00:00.00. Excel won't accept this format without converting it to some type of time. For instance if my number is 84:24.04, it will convert it to 24:24.04. That is after I change the standard custom of mm:ss.0 to mm:ss.00...

Hi, I have a list of numbers that I have been inputting into a column. The problem I have been encountering is due to the different numbers being entered into each cell. I have data with numbers from 6 to 14 characters long. I have tried to format the cells with; general, numbers and custom each...

I have a list of data that I am cleaning. It has 5 columns. I need the following to happen to get the data in the orderthat I need it in. I have tried everythingI can think of, but I keep ending up with issues. Column D is a combination of 2 letters, i.e. XA, GS,RY. It will always be two. I...

Hi, The only data I would like inputted into cell F15 are numbers 840, 841,842, 843 & 844. Also, you can only input into this cell (F15) if cell B15 is populated. Little stumped on this. Can someone help me with the data validation formula please? Thank you!

I was wandering if it was possible to have a cell that when you entered 240 and hit enter it would show 240 (20')? I was hoping this would be possible with the custom option in the format cells dialog. Thanks for the Help.

I have a workbook that has about 38000 rows of data and about 20 columns. The workbook contains a custom view with about 6 custom views on the dialog list. The custom views filters the data. A typical filter may involve 2 to 6 columns. The workbook has a formula to count the rows...

Hello, everyone! I am trying to create a spreadsheet to track action items for contract task orders. To make things easier for me to avoid formatting mistakes (the spreadsheet will be editable by more than just me) I would like to create a custom formatting that takes an entered ID number -...

Hi All, Apologies if this is totally daft, nube etc. I'm fairly green to excel, so your assistance and forgiveness is sought after. I have been given a date in the following format as plain text "MAR 4, 2019" and I wish to convert it to 04/03/2019 using excel. I have 1400 different the...

[<=1000000]#0.00,," K";[>=1000000]#0.00,," M";0.0 Hi Folks. What would I do to make this custom format display a $ sign followed by one space prior to the number? So instead, for example, of 5.21 M it would show $ 5.21 M. Thanks in advance for your time!! Best, Aimee in Madison

Hello - I hoping someone can help me with this. I created a macro using the Macro Recorder to sort a column on my spreadsheet by a custom list. CUSTOM LIST: PROJECT CANCELLED STAGE 1 - PI STAGE 2 - RD STAGE 3 - W STAGE 4 - LV STAGE 5 - LD PROJECT COMPLETE VBA CODE...

Hello, I would like to sort my data by the data in column A whenever I add new data to that column. I can easily sort the data alphabetically automatically, however I would like to sort this data by a custom order. The 4 different inputs allowed for this column are 1. keep/sold, 2. must win...

I have a column in an excel sheet that users input data I want to make it so they can't miss something important. Using data validation custom formula works great to ensure the user only inputs ##-##-##[A-Z]### however I want to be able to allow them to add multiple entries into a cell with only...

Hello Sir, I am trying to find or enable the new Insert Custom Visual experience in Excel 2019 Pro Plus (Microsoft Excel 2019 MSO (16.0.11328.20156) 64-bits) My Excel is not showing this in the ribbon. I am using Version 1902 (build 11328.20158) There is a chapter called Try Example...