pack

  1. T

    Transpose rows based on specific text

    Hi all I'm trying to speed up the transpose process. When I copy an order form from online it pastes it all into Col A but I need to make it easier to read as I already have the next stages in place. The problem is the site changes from time to time and I have to redo the sheet. The common...
  2. T

    Formula to Multiply by a cell value

    Morning, For the life of me i can not think of a way to do this. So im trying to set up a spreadsheet for inventory management. I have the following formula in cell E2 =IF([Average_Qty per week]>=3,[@[Average_Qty per week]]*D$1,(D$1/2)*[Average_Qty per week]) But i would like this to have...
  3. John.McLaughlin

    Find column, then copy a dozen cells from it?

    Trying to improve my pack list. Our worksheet has a unique product number at the top of each column. The cells of each column contain description, weight, size, price, etc. I want to copy the contents of the column (approx 8- 10 rows each) onto a packing list. Currently I find the column...
  4. J

    Break down a total quantity into columns

    Hello All! Got a query which I hope someone can help with.. I have a spreadsheet that I need to create for work due to a new process. Essentially what I need help on is a formula which automatically breaks down the allocation (column B) into packs (columns D-M). Below is a shortened version of...
  5. C

    Combining Vlookup and IFS

    Good afternoon. I have two tables as follows: Table 1 has a client's name, and pack mode. The pack mode can be any of three items (FCL, LCL or LSE) table two has two columns, one for pack mode and one for the related price. Each pack mode has its own price. I need to do a vlookup in table 1...
  6. D

    Consolidate Multiple columns into one Columns

    Hello All, So I create product upload CSV and each product has a different choice such as a Size, Unit, Color, Size and Units, options etc. These choices are all on different columns however I need to consolidate all into one column at the end. The reason because I need to upload the choices...
  7. B

    Conditional formatting for different answers?

    Hey Guys, I've got a pivot table infront of me and just wondering if this is possible. Pivot table columns go as: Mechanic - Brand - Pack - Account I need all of these as they are. The next column is months. After this I have financials. I want to create a conditional format where...
  8. J

    Formaula Assistance

    I own a small business and I'm having trouble with employees adding incorrectly and I'm wanting to create a spreadsheet that will do the math for them. As a part of my business I sell lottery scratch off tickets. Each ticket is numbered and we count them down at the end of the day to determine...
  9. F

    What is the VBA code to click on a Hyperlink, review the page and get back to the main sheet

    Hello, I have a list with 3 columns: Package Name: Latest Date: Link: The VBA should click on the link, go to the linked sheet, capture a value and return to the main page. I have a problem with writing a loop to go through the link in each row. Can you please help...
  10. M

    SUM CELLS (not adjacent) and some have #N/A

    Hi, I have multiple Rows (within a Column) that I want to SUM but some have #N/A in them. When I have the formula to create the Total, I want to be able to drag it across 24 Columns. I have found 2 examples - both work in various situations but not my specific one. Can anyone suggest a...
  11. J

    Index/Match Non-linear Logic

    I have the following table structure. I am attempting to pull in the Planning rate associated with the Part No. The structure (if you look towards the bottom of my table) is not stable - sometimes a product may have 1, 2 or 3 lines (they could, conceivably, have 10). The structure may have...
  12. M

    Distinguishing between 2x and 12x with IF(ISNUMBER(SEARCH

    Hi I have a sheet where I'm extracting the pack size of a product using IF(ISNUMBER(SEARCH then multplying that pack size by the units of the product. However, there are some products where the pack size is 2 and others where it is 12 eg Chocolates 2x250g Chocolates 12x250g Excel can't...
  13. J

    If cell has pack or pk return Pack of 100 or pk100

    Hi, I am wanting a formula for this spreadsheet. Column A has a list of descriptions for example "red pens pack of 100" or "red pens pk25" What i am wanting is in column B to pick up Pack of 100 or pk25 (numbers would change). Ive got partly there with this...
  14. T

    edit my index match Formula to say if SKU has the word Multi4 or Multi3 etc times result by that number?

    Hi everyone, I've got a bit of a problem I do an index match of my sku's to tell me my stock levels from my weekly CSV readout. I put the data into sheet "CSV" the simply have a formula in sheet "Stock Level" that index matches the Sku in "D6" (for example) with the data in sheet "CSV" CSV...
  15. A

    Difficult formula, please help

    Bitcoin calculator - Google Drive Hi guys, I'm new to the forum and need some help. Above is the link to a calculator a friend has made however it's not quite finished. How it works: I start with a number of packs (B10) which is determined by the starting balance (B3) and each day the...

Some videos you may like

This Week's Hot Topics

Top