abcde

Hello, I am looking for a formula. I have one tab with raw data, multiple records, multiple duplicates, etc (tab named [raw]). I have another tab [Plan] where I need to insert my formulas. In my reference cell A1; I will enter a unique ID number. I want to use that value I entered in A1 and...

Example: I have one item number ABCDE but this item number appears 3 times, on rows 1 through 3. Each row lists a different raw material off the bill of material, along with the budgeted tons. Material A 5 lb. 500 tons ABCDE Material B 1 lb. 500 tons ABCDE Material C 2lb. 500 tons...

Hello, I have two tabs. [tab1] is a mailing list. This tab holds a bunch of information regarding a marking letter which was sent; information fields are: [Customer#], [dateSent], and [colorPrefer]. <tbody> [tab1] A B C 1 Customer# dateSent colorPref 2 12345 1/5/2018 red 3...

Hello - I have the formula below but want to add ability to catch if B7 is not an exact match due to letters being lower or capital. i.e. ABcDE would not match ABCDE. I tried to add TRUE and EXACT terminology into the formula but could not make it work or I had it wrong somehow... ugh. Any...

Hello, I am looking to see if i can do the following in a formula only. I have a headache from trying so hoping one of you experts can lend a hand i would be grateful. Thanks in advance! Note I used cells a,b,c,d,e etc to make the example easy, but I need to be able to use this anywhere in a...

I need to vlookup a set of information from one spreadsheet. Problem I am having is the table array which i am selecting has multiple records with same unique value I am using. I want to get the data with the latest datetimestamp. The dataset is not massively big but has close to 200K rows...