cat

Hello I am needing some help or ideas of how to easily transform original data into a simplified list, ideally just a pivot, but because my original data has tons of columns and due to the circumstances.. I am giving up hope that there is not an easier way to do this.. Background: 1. It is...

I'm sure that this is already plenty of threads for this, but I'm not sure how to explain what I wish to achieve. Currently I have a list which has a description in. I want this referenced in another table, however I want all the descriptions which match to be grouped together. For example...

I am trying to figure out some way to take a string and make sure its a certain number of characters (I would say width but that would be much more involved given characters and point sizes are so confusing!!!) and center it via spaces. For instance, if I have a string "cat" but I want it to...

I have a web form that collects data, there are 4 radio buttons depending on which radio button has been selected the value of that radio button goes into column B Radio buttons <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings>...

Hi all. I know i can use this formula =IF(ISNA(VLOOKUP("*"&"Hat"&"*",$A$1:$B$10,2,0)),"",VLOOKUP("*"&"Hat"&"*",$A$1:$B$10,2,0)) in the below list to find the number 3. dog 1 cat 2 tophat 3 cow 4 pig 5 But how would i be able to find the number 3 doing this...

Hi , I have four rows as mentioned below . Column1 Column2 Column3 Column4 Column5 Apple Bat Cat Dog Egg Ant Bag Can Den Eat Apple Bat Cat Dog Egg Air Big...

I'm working with a rather long list that I'm trying to add to the end of a spreadsheet. I know there are formula's out there that can go to the next empty cell in a row or a column, but I need a vba code that can go to the next empty cell in a row based on the first column's value. For example...

Hello. To keep it simple, if column A contains the letters A-C and column B contains strings, how do I return the correct letter (B) in the cell ??? (D1) when I type dog into C1 please? I believe I need to use an array formula containing SEARCH, INDEX and MATCH. I have to use a formula in this...

Hi All, I have the below code to count through columns BL, BM and BN on my Completed Sheet. The information entered into these columns can be - 1.1 or 1.2 or 2.1 or 2.2 or 3 or 4. The information is then pasted into OverallStats Sheet columns C22 to E28. Row 22 being 1.1, Row 23 being 1.2...

Apologies My brain is not working this Monday morning! Can someone please help and translate the following into a formula :) IF B1 CONTAINS "cat" AND c14= "CR" then display "NA", IF B1 CONTAINS "dog" AND c9 DOES NOT CONTAIN "dog", then display "NA" Otherwise display "1" Many thanks

In cell A1 I have a word, for example CAT In cells B1:B10 I have a list of different words B1 = CAT B2 = SCAT B3 = CATH B4 = SCATHE B5= CATS B6 = DOG B7 = CATHERINE B8 = NOCATCH B9 = HORSE B10 = GIRAFFE What I need a formula please is to look at what is in Cell A1, and return the first result...

Hi guys looking for a hint on what my problem is with the following code. I searched all worksheets and pulled back 3 sheets beginning with 1234567 which are in a string I need to now unhide sheets with the names from the string e.g 1234567 CAT to unhide sheet called 1234567 CAT any help...

Hello, First time poster, long time reader. I'm trying to figure out a way using VBA where a user can specify values in 2 adjacent cells with a quantity in a 3rd cell, hit a button and have it insert the values entered a number of times equal to the quantity specified. Example Input: <tbody>...

If in a workbook I have a column of importance, in this case Animal. I have multiple Cats. I do not need all the Cat rows, I just need one with the lowest Start and the highest end. So, in this case my result would give me one row with Cat like so. I want to do this for all of the Animals in...

You probably read this title and thought "=sumif, dummy". However this dummy can't seem to get it to work nicely in this case. Would love some assistance. To the issue: First off, I know I could do this via VBA, but I would love to be able to accomplish it with simple formulas if possible. I...

Hi Guys, I am looking for a way or VBA to check all data in a selection of cells and put them in to a table with a count of how often each word appears. Example: The Cat ran to the second cat The -1 Cat-2 Ran -1 Etc

Hello, new to vba and I need help writting a UDF I need a macro to get the position of the first character of a repeated sub-string of a string If cell value is "The green cat something1 the green cat something2 in ... green cat somethingM" Sub-string is the nth instance of "green cat" How...

Good Morning, I am trying to find a way to populate data into columns, based on a postcode entered into Shee7 (Postcode) "I14" and assigning a macro to a button titled search - which runs the function / routine once pressed. If no postcode is entered - I want a MsgBox "Please enter postcode"...

Hi, Awhile ago wideboydixon helped me and built a formula to combine all possible combinations without duplicates or reverse order duplicates. Previous thread: https://www.mrexcel.com/forum/excel-questions/989848-combine-all-possible-combinations-single-column-without-vba-2.html#post4750264...

Hi Just wondered if anyone can help with a formula to count out items in a list based on a count in another range with a criteria. So in the example below the little box says how many to count in total and from the list I wish to count out that many with an added criteria and if more to show...