lot

Hi there! I'm really not sure where to start... I'm making a basic Dashboard to allow me to track Production figures in our business. I've set the spreadsheet up and I'm now in the process of creating a 'Summary' sheet that will collate all of the figures. The Dashboard is completed WEEKLY...

Hi I have this sheet (please see the link below) and I want to separate them into columns. Text-To-Column did not do the right job. Is there anyway to do clean separation in case like this. Thanks a lot. https://docs.google.com/spreadsheets/d/11opqWXTJ1-N2-yFID7yjMWjnJCNO85nV/edit?usp=sharing

Hi im reposting this question because i think adding responses to my own question caused others to ignore it. im trying to do an averageif based on if the range contains a certain word, here is how I tried it =AVERAGEIF(D2:D892, "*"&LEFT(D2:D892,(FIND(",",D2:D892,1)-1))&"*", B2:B892) But the...

Hi there! I have a workbooks which contain 24 sheets. I want to disable the formulas on all sheets (All the formula cells should return zero, blanks, error or any other), If the date in sheet1 cell A1< today(). Manual editing the formulas on all sheets required a lot time. Because there are...

Hello all, I am newer to excel and I have ran into a little snag with a spreadsheet system my new office is using. What I need to accomplish is to move all data up in a column to the top of the page and successfully remove all the blank spots. I have to do this for hundreds of lines so the copy...

Dear mrexcel community, My questions is; <colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody> Jan Feb Mar Apr Item 1 10 20 40 10 Item 2 20 20 30 10 </tbody> Suppose there is a dropdown menu for item 1 and 2. When...

Hi All I am trying to set up an "if()" equation where I did like to controle the number to insert based on a cell with or without "x" I have got to the following equation, but it does not work. =if(AN16="x",BE16=AH16,BE16=Z16) So the idea is of course that if AN16 has the value x then...

It looks like the MrExcel forum recently exceeded 1,000,000 threads! Quite a milestone. That's a lot of answered questions! :beerchug:

Hi Is it possible to change number to text. For example if I type 1,3,5, etc. I want excel to display them like One, Three, Five etc. Is that possible with Number formatting or any other way? Thanks a lot.

I'm tryin' here...just can't get it... Using this formula in the worksheet: =IF(INDEX(B388:B404,MATCH(TODAY(),C388:C404,0))<>"","N","Y") And it works just fine. Just can't seem to get the VBA syntax right. Do I need to use the...

Hi all, hope someone can help with the following. Using Excel 2016. I'll try and explain what I am trying to do as best I can. I have a spreadsheet with a lot of data in a single column A. This could be from A1 to A500. Each cell in the column contains a lot of text from extracted emails...

Hello, I am working on developing an array formula that will skip over cells that equal zero or blank. I have two types of products listed in eight lot categories. Lot one is S-Lot and Lot two is H-Lot. Each lot can have four categories. The trouble comes in here. The maximum number of lots...

Hi, <tbody> PRODUCTS LOT NO. ERROR TYPE ERROR COUNT TOTAL LOT QT. PRODUCT1 1 ERROR1 2 200 PRODUCT1 1 ERROR2 3 200 PRODUCT1 1 ERROR3 5 200 PRODUCT1 2 ERROR1 2 500 </tbody> I have a similar table to follow production errors. To be able to create a graph later, I don't use a Pivot...

Hi every one I have a table like below. <tbody> Name Category Score John A 127 Mike B 184 Jane A 124 Fred C 201 ... ... .. </tbody> I want to separate the table based on "category column and save it in a new workbook and save the workbook to category name. for example one of the...

Hi, I'm looking for a way to concatenate vertically based on column A and B and put it in a new tab: Basically my data looks like this: Column1 Column2 Column3 A 1 DataXx A 1 DataAA A...

Hi Guys, I didn't find exactly what I was looking for, and maybe you can help. Basically I have a document with thousands of lines of data. The data is organized across per row. Columns; A, B, C, D, E, F, G. A: Has a Name, we'll call it "Apple" My array is from A2:G2000 Example: <tbody>...

Hello friends, I'm rebuilding an extensive spreadsheet containing a lot of macro's. To make maintenance a lot easier I decided to create a pivot table. This works fine, but it doesn't look the way I like. Main concerns are related to 'Subtotals'. They do not show well and for a static sheet I...

I want to calculate "D04" Subtotal for "M" only in "D02" according to "Date" filter Thanks a lot in advance P.S.: I couldn't upload an Excel file