widget

Hi I have a packing list on an excel sheet with 2 columns. Column A contains a PartNumber, Column B contains a Quantity Number. So, e.g. column A "Widget", Column B "5" Meaning we received a quantity 5 of "widget" I want to print a separate label for each widget, any suggestions on how...

I'm stuck. I have several hundred rows of data with various columns (see example): <tbody> Date Segment Product Sales Rep Region Sales Jan-18 Enterprise Widget 1 Bob MW $500 Feb-19 SMB Widget 3 Cindy NW $250 Jun-18 SMB Widget 3 Suzzie SE $1000 Jan-19 Commercial Widget 2 Bob SW $35...

I need help creating an ifs formula that will calculate based on a minimum number. Here is an example: <tbody> TABLE 1 Widget --Widget Length-- --Widget SF-- $$$PRICE$$$ </tbody> <tbody> TABLE 2 --Widget Length-- --Widget Cost-- 0-24' 5 25'-28' 10 29'-32' 15...

Hi All! I have a spreadsheet with more than 15K lines of data. This is the product of combining about 10 different versions of the same spreadsheet (there was no real version control before I started working on it). The data are grouped by content in cells in column A (VBA code to insert blank...

I am using PowerPivot Excel 2016 data cleaned in PQ The data is formatted like this Item Name Item 1 Start Item 1 Running Item 2 Start Item 2 Running Widget 1 15 1.15 12 1.63 Widget 2 9 .79...

Hi, I need to format a data set for a mail merge. In essence I am looking for help on how to remove blank columns and replace it with the value of the next non-blank cell in the row (without the use of Macros). Blank values are allowed in the Widget columns are allowed Each email address will...

Hi all I am looking for a formula that is going to count all of the consecutive months equal to or over a set threshold (in this case the threshold is $10). The goal of this project is to count how long capital is invested in a project before it is paid back. My problem arises in accounts such...

Hello. Is there a way to use other functions with the SUMBYCOLOR function? I've not been able to get it to work. I would like to sum data that has a specific background color, within a specific date range, containing specific text "Widget #1 " or "Widget #2 ". Example: Summarized data should be...

Hey Folks, I'm hoping for some advise on how to take the value in 1 cell of 1 row and convert it to a different sheet over 4 rows adding some constant text before and after the cell value. For every row in Sheet1, column H (only if it contains data) I need to use the cell value and add a...

Hi All, I'd be grateful if you could have a look at the scenario below and contribute any suggestions please: Scenario We have 5,000 widgets available to order We make widgets to order and can produce 50 a day It's important we can tell customers their expected wait time for their widget...

Hello, just wondering if it was possible to take my excel sheet and put it on my computers desktop instead of having to open and close the folder every time I need to use the program. Also is it possible to make it "intractable", by that I mean make changes on excel while its on the desktop. Thanks.