unit

Hello Mr. Excel! You guys are always extremely helpful, so I have another question I would greatly appreciate your help with: In column P I have a list of Unit #'s that need to be updated in an online system. In column BA I mark off units that have been updated (I type the word "Yes")...

Hi, i am new to this forum and request some help on excel. i intend to use 3 conditions on the below table. the formula i used is =if(isnumber(match(b2,A2:A5,0)*AND(c2="",b2,0) however i am unable to extract the required result. <colgroup><col><col><col><col><col><col></colgroup><tbody>...

Good morning, I have a rather large data source file with a large pivot table. In another file, I need to pull several pieces of information in order for a macro to work. The problem I am having is that the volume of GETPIVOT formulas I currently have are really bogging everything down. The...

<tbody> column B colum j columnP columnR total of unit unit + unit minus 1unit =remaining unit unit unit =total of unit i insert new row everyday...

Hi, I'm trying to find out how many reams of A4 paper were purchased last year but I only have the total spent per month. The price may change monthly since there may have been purchased from varying suppliers. Is there an easy way in excel to get that information? For example the below...

Hi team, hoping you can help with the index,match formula to find the occurrence where the storage unit is not blank (or zero). The formula is referring to a table (called "Runners") in another sheet. The table is refreshed every hour throughout the day to bring in new data. Unfortunately there...

Hi there, I am looking for a formula that searches through the bold column and returns a corresponding value (I.e Drummin, End Unit, Hardwood Floor etc.) on one single row. This is a sample size of a larger spread sheet and I need the formula to run through the entire document and automatically...

Hi All, I am having trouble trying to work this one out. I can't figure out the formula that goes in the green cells highlighted below. In the green cells I want to increase the cost base of each property by the % from the data below, based on whether the property is allocated as a house/unit...

OK I am having trouble with an IF LOOKUP formula SHEET 1 <tbody>#DAE7F5[/URL] "] A B C D E F G H I J K L M N O P Q 1 2 #000000[/URL] "]Product #000000[/URL] "]Lot #000000[/URL] "]Subdivision Stage #000000[/URL] "]Classification #000000[/URL] "]Quality #000000[/URL] "]Type...

Hi all, I have a very large spreadsheet (7000+ rows). Column B contains various Customer Names that repeat (column name: CUSTNMBR) Column K contains the Unit Price of each invoice (column name: UNITPRCE) I need to know which customers show a unit price of $0.00 AND $10.00. Can anyone...

Hi, I am trying to have a cell show an icon set based on another cells value. The other cell being a percentage value. I have it working... almost. It turns out that the cell I am placing the icon set in is a Unit Price cell (column) which is looking at a cell elsewhere in the workbook. When...

Hi, I'm a bit confused by the EARLIER function. Here is my formula: DISPATCH_TIME = MINX(FILTER('Query1','Query1'[EVENT_NUM]=EARLIER('Query1'[EVENT_NUM])&&'Query1'[UNIT]=EARLIER('Query1'[UNIT])&&'Query1'[UNIT_STATUS]="DP"),'Query1'[CREATE_DT_FORMAT]) So the formula will return for me the...

Hi, I am trying to create a new column in Power BI that will allow me to group my data by a subset of the entire table. Here is what I am trying to accomplish. <tbody> Event Number Unit Status Group Number 1234 Truck DP 1 1234 Car DP 2 1234 Truck AM 1 1234 Car AM 2 1234 Truck DP 3...

Hey guys, So I have a sheet that has a list of items (A5 through A20,000, approx). Column B is for unit prices but they are not filled in. I want to populate this column for only specific items (as we only use maybe 100-200 of the 20,000). Is there a way to use a searchable drop down box to...

Good day again, I need to find the Max volunteered hours for each unit. I believe this is going to be an array, but could someone help me put it together. Data Table <TBODY> Unit Employee Total Volunteer Hours 1 a 12 2 a 24 1 b 57 1 c 35 </TBODY> The result table should look like...

Hello, I tried some vba examples but couldn't quite get the following to work. I have about 50 charts per sheet on a worksheet. Is it possible to change the y axis for the 50 sheets on a sheet with vba, without affecting the other sheets? Right now for example, I have MIN: 0 MAX: 50 MAJOR...

Hi pls help Can i send my worksheet, i cant sumproduct 2 columns (unit x price) with a filter criteria (groupA)

I am trying to figure out a way to search a range of columns for any thing that starts with an open parentheses and ends with a closing parentheses. Copy that data into one cell and then remove that txt from the original cells. I would prefer to do this using VBA instead of a formula but I am...

HI, I am trying to make a summation of how many items had been sold in a month but the items have different prices. Table format is below. I combined all transaction for 2017 and made a subtotal for each of the month. <tbody> year Month Date Customer Product Quantity Given Price per Unit...

Currently in Aus. a lot of new Chinese immigrants are buying units so developers are kowtowing to their tetraphobia by building unit blocks without a fourth floor or floors without the number four same goes with the unit numbers. See link...