abc

I'm working to create an allocation model to quickly determine whether or not an order can be supported when compared to the available inventory. For example, I have 3 customers, each in their own tier (1,2,3). Tier 1 customers will have priority and first dibs at the available inventory, then...

I am trying to highlight duplicates across two columns. So when a selection from column A and a selection from column B occur more than once together in the table, they are then highlighted. I can get it to work with duplicated entries from a single column, but not from both. So for example...

Hi I have a spreadsheet that used as a sales report with 12 worksheets one for each Month, and a dashboard worksheet. On each monthly worksheet I have column B that contains the names of a companies that has purchased from me Column C contains the value of the sale Is there a formula that I...

OK real simple one I just can't think how to do it... I have a column A which is where I want my numbering to count up Column B has company names In All the company names are In order but there are multiples of the same company name so: Abc Abc Abc Abc Def Def Ghi Ghi Ghi And so on...

Hi I need help on how to extract unique name from the excel cell and then sum up the total score for each name. I have excel sheet where the name for all participates has entered in one cell as example below Name Score ABC;#DEF;#HIJ;# 5 ABC;#XYZ;#HIJ;# 2 MNO;#DEF;#HIJ;# 3...

Because the heading is so clear! I have the following data: <tbody> A B C D E F H I J K UPN Name Year SEN Care FSM Subject Type Class Points 123 abc 7 S Y Y Geography Homework 7L4/Gg 1 456 def 7 Technology Homework 7L4/Te 1 678 ghi 8 S Y Science Disruption to Learning 8a/Sc3 2...

I am trying to create a task list of pending tests on 1 main worksheet from another worksheet with multiple account numbers for the same person. I need to match the account number (which is repeated multiple times on the worksheet I am pulling from) to a column that may or may not have a date...

Hello, I am have an urgent task for work and have gone through the various threads on this site, but, I could not find anything. I have to be able to quickly sum the total based on multiple criteria and remove the duplicate rows (Tab "Data". Then only certain columns are copied over to a...

How to use =SUMIFS for below table in power bi. =SUMIFS(PRIOR MONTHS,REGION,SALES REGION,UI,PID) <tbody style="box-sizing: inherit;"> Prior Months Region Sale Region UI PID Europe Europe ABC ABC 12 Europe Europe XYZ XYZ 12 Europe Europe OPQ OPQ 2.5 Americas...

Hi I am familiar with left, right and mid but am unable to get the results below in a streamlined way. I was able to convert the rows using text to columns and then do a concatenation of just the characters and do the right for 3 characters but that is quite painful and not repeatable for...

hello i have a sheet that looks like below layout with unique identifiers in the columns. Looking for a formula to help tell me how many of each identifier there is. for example results would be ABC=2 BCD=3 EFG= 7 Note some columns could be blank, not sure if that impacts anything..ty <tbody>...

Hello, I have various spreadsheets that can contain mailing addresses with anywhere from 60,000 to 140,000 records. On certain records the street address, which is represented in one cell, is listed as a range of home address numbers, such as 145-150 Smith Rd. The City, State and Zip are also...

I am looking to be able to insert a hyperlink to a column of words to email a set recipient based on a VLOOKUP i.e. Column A: ABC ACB BAC BCA BAC ACB ABC BCA EmailAddressSheet: ABC | ABC@outlook.com ACB | ACB@outlook.com BAC | BAC@outlook.com BCA | BCA@outlook.com Does anyone know if any...

Hello, I have a large data set that changes often. I need to parse out by manager and administrator. There are 27 possible combinations. I am hoping to move the data, including the headers, for each manger/administrator combination to a separate tab named for that combination. So in the main...

I have a list of names, departments and phone numbers in row A. Entries are separated with a cell with 0. Here’s an example of the layout of the data. <tbody> John Smith ABC 999-999-9999 0 Jane Smith ABC 888-888-8888 777-777-7777 0 Alex Smith ABC </tbody> Some entries have more...

I have the table below and I need to write a VBA script to change table 1 so that the data looks like table B and pastes the data in a new tab in the same workbook The only distinguishing features between the rows is that one is bold and the others are not. The Bold is the overall group and the...

Hello All, I am looking to improve the output of this small VBA code below. At this point I can copy and paste values without being a table in Word (Unformatted text). Keep in mind the example shows only 3 cells, but I am looking at over 40 cells over a few worksheet. Now I want to add a...

Hello All, I am looking to improve the output of this small VBA code below. At this point I can copy and paste values without being a table in Word. Now I want to add a carriage return or more between cells values. Example.: A2 = ABC, B2= DEF, C2= GHI The output in Word will be: ABC DEF GHI...

Hi, I have a long list of uncleaned data of account names with similar names. See below example. 1st col below shows that there are 5 accounts, but after manual adjustment line by line, there are only two accounts namely ABC and Foser. Is there anyway to use formula to remove duplicates...

Dear all Could you help me with this issue please? I would like to sum only the transaction that does not contain "APPLE" Ex : <colgroup><col><col span="3"><col></colgroup><tbody> Num Name Debit Credit 1 APPLE 1000 sum only Num 2 and 3 1 ABC 100 due to 1 contain "APPLE" 1 001 900...