cat

Hello, I did a list as suggested here : https://trumpexcel.com/excel-drop-down-list-with-search-suggestions/ It works very fine. However, I would like to improve it for my needs. My list in column F contains cell with many words, separated by a coma : “,” Example : F3 : house, cat, hospital...

I have a large set of cells with Text inside I need to sort into lists and in such a way that each list produced from the first omits one cell. The difficulty for me in particular is that the number of cells can vary. To illustrate simply below is a simplified set of cells with one word in each...

Hi all, So I need help writing a formula, not in vba, that looks at a number in column A, then looks at another sheet. Finds the value from column A in a list. If a value isn't found, it returns "Check". For example: <tbody> Sheet 1 A B C 1 Dog 2 Cat 3 Frog </tbody> <tbody>...

I currently have this formula in a cell in my spreadsheet: =VLOOKUP(C21,'LEMS Rates'!A$1:D$1303,2,0) I am trying to figure out how to modify it based on some IF circumstances: IF 'Cat & OH&P Markups'!A2 = 'LEMS Rates'!B1 It should use that formula or IF 'Cat & OH&P Markups'!A2 = 'LEMS...

Hi all, I am trying to write a case in OBIEE for the first time. It does not like what I am doing. Can you take a look? I am trying to write a case based on the customer name ( we have about 15 special names give or take) that need to be identified, the rest get assigned to a category called...

Hi, I have 10 text-joined rows, A1-A10, each with up to 12 items and separated by a " / " as the delimiter. Is it possible to flag duplicates with a color, including when the order might different? i.e if A1 has bear / fish / cat and A2 has fish / bear / cat then they will be considered...

Hello, Need your quick help. I'm trying to write a formula where from a group I can find if it has a text (specific/partial). "Has Black?" is the result I want. <colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody> Animal Color Animal Has Black? dog...

Hello I have made an example of my problem below where I want to match data/ get to know if it exist in a group, separated by an empty cell. All "groups" are put in the same row and have a header. How can this be done by formulas? How can I confirm if Header1 has cat? How can I confirm if...

Hello everyone, Not sure if this is possible, but I think to think "All Things are Possible", so I figured I would ask. I have some data where the first column is category then every column after that is id's for that category. <tbody> A B C D 1 Cat 1 1000 1200 1450 2 Cat 2 1002 1305...

Hello Wonderful Helpers, I'm wondering if there is a formula that can count until a leading cell changes content. When the cell changes it starts back at 1?? I need to do this on a large scale. For example: <colgroup><col><col></colgroup><tbody> Fox 1 Fox 2 Dog 1 Cat 1 Cat 2 Cat 3...

I have two worksheets' data. Worksheet Tags. Worksheet Records. Only Worksheet Tags has data in col P. Worksheet Tags has only SOME of the same data in col A that Worksheet Records has in col A. With matching data in col A, whatever I can do to copy Worksheet Tags' data in col P, inserting...

Hi all I am trying to find a value from column C in Columns AC:AE inclusive and if found return the row number of the initial value for example: If the value of C2 [DOG] is found in F7 then 2 is returned to A2 Column C will contain unique values Hope this makes sense - even if the example is...

Is it possible to highlight duplicate cells in ROWS only whereby any text or numeric value is highlighted? So in the below table Row 1 - nothing highlighted Row 2 - Cat highlighted Row 3 = 555 highlighted (ignores 55) Row 4 = Both Cat and 555 highlighted A1000 Lee Steve Darren Martin...

Hi Guys, I'm trying to remove the blanks from an adjacent column as per the table below. Any ideas from you wonderful people? <tbody> Data 1 Data 2 Result 1 Cat Cat Dog Chicken 1 Chicken Sheep Cat Apple 1 Sheep 1 Apple Banana </tbody> Thanks!!!

My spreadsheet has two non adjacent columns:- Col 1-Col 2-Col 3 Dog-blank-12 Jan 19 Cat-blank-13 Mar 19 Cat-blank-04 Jan 19 Cat-blank-08 July 19 Elephant-blank-22 May 19 Dog-blank-25 May 19 I'd like a formula for Col 4 that shows me the latest instance (from the dates in column 3) of each...

I must compile over 60 multipage paper surveys. The 1st question has 20 possible responses and the users marked all that applied. The easiest method I can come up with is to "x" the appropriate box and excel replace the "x" with the column title. But I can't get it to work. Can you suggest a...

Hi, I have a ComboBox embedded in a worksheet that references a list of items. Ie: small cat cat big cat small dog dog big dog Right now when I type in 'cat' i only get 'cat' as the suggestion. What I would like is to get all items that contain 'cat'., ie., in this case: small cat cat big...

<tbody> Type Date Dog Date Cat Date Dog 1/14/2016 Dog 1/14/2016 Cat 7/8/2018 Dog 5/8/2017 Dog 5/8/2017 Cat 7/8/2018 </tbody> Given Column A:B, I want to distribute the dog data to the dog columns {C,D} and the cat data to the cat columns {E,F}. Any ideas? Thanks!!

Hello all, I'm trying to make a column that automatically grabs the values from another column, makes sure they are unique, and then alphabetizes them. Animal <tbody> Alpaca Dog Cat Dog Elephant </tbody> Should return Alpaca Cat Dog Elephant This is the formula I'm using...

Hi, I am unsure if this already exists but have spent days looking for what I need and cannot find it. What I am looking for is a VBA that will provide all possible unique combinations within a range. The range will be variable to input - in column A from 1 to 12 entries. Lets say- A1 -...