find & return

  1. D

    Find all cells in "A:A that contain "B$1$" and list all values starting in " B$2$"

    I have a list, in Column A, of 900 customer codes. Examples are AFP, AU3, NKD, YM2, JWW etc... They could be anything, but are always either 2 or 3 characters. In Column B and Column C I have those codes broken down into the "First two characters"(column B) and then the "Last two...
  2. M

    Populating one ws from another

    Hello! I have two sheets. Sheet 1(NOM ROLL) has with id numbers in col A and spaces in col E and F. Sheet 2(JMES) has a subset of the id numbers in col B and in Cols J & k, strings. I need to find the matching ids in (s1)A and (s2)B and where they match, copy in (s2)J&K into (s1) E&F. Below...
  3. R

    Búsqueda y copiar valores de filas

    =IF(ISNA(VLOOKUP(B9,$F$2:$F$15720,1,FALSE)) = TRUE, " ", D9) Buenos días, me uno a este foro porque estuve buscando solución a un problema que no logro resolver,ya busque en Internet y en este foro y no encontré algo que me pudiera ayudar por este post. Lo que pasa es lo siguiente: Tengo...
  4. A

    Need help to find text before/after specific character in a string

    Hi, I've multiple entries in column A, which are Text/Number/Character strings and i've created unique set and placed in a row to search the same text in the Column A and return the value at the end of the string. I know it is difficult to explain, here is what is appear like Column A Customer...
  5. P

    Find Max Alphanumeric Serial Number

    Hey Guys, I am looking to find the Max Alphanumeric Serial Number that is in a column and increment by 1! I have code that finds the last "Sequential" serial number in the column and it increments by 1 but unfortunately all my Serial numbers are NOT Sequential in the column! Can someone please...
  6. S

    need help to find text in sheet1 and return column date but only if greater than today

    ok I have searched everywhere but cannot solve this problem I've been dealing with for over half a year. I have an excel sheet with a daily schedule of items. equipment id is the left column and dates across the third row. I need to find text in the sheet and get the date it falls under, but...
  7. D

    Display cell reference based on the data in a cell that is part of a sum record

    I used Excel to figure the payroll commission that we pay our salespeople. I have an individual worksheet for each person that totals in the same manner for everyone. At the end, I have a page that totals all of the individual totals. We use a "draw system" for paying our employees, which...
  8. F

    Formula to extract values in multiple parentheses within a cell. Example: Eric (2), Dana (3), Tina (4)

    Hi Everyone, Here's what the data looks like that I'm working with (within a single cell; A1): Eric (2) Dana (3) Tina (4) I am looking for a formula that can extract the number within each pair of parentheses and place each number in a different cell: 2 in cell B1, 3 in cell B2, and 4 in cell...
  9. P

    Sum a column based on one criteria

    Hi Guys, I have been wrecking my head with the following! hope you guys can help? I am trying to look for some VBA Code so that I can search multiple values in Column "A" based on the criteria in Textbox1 and SUM up the corresponding values in Column "B" based of course on the criteria in...
  10. W

    search and return challege!

    Hi, i am trying to find a value in an array based on partial input from a user. The user will enter the last four digits of a number. then the fomula should find the number in a list and return that complete number i will explain using example. here is the list of numbers (array): <TBODY>...
  11. A

    Extract specific text from column and put in a new column

    Hey all! I need to search a list in column B of 500 records to find specific words such as"ABC2000000000" The text will always begin with "ABC................." and I would like to extract this whole world from the text string into a new column. This is not always in the middle or beginning or...
  12. G

    Excel Macro - Find Activecell.value

    Hello I was trying to google it and checked on forums, but couldnt successfully found any solution to my problem. I have a list of names in coloum D of a worksheet called "Trial", I have another worksheets called "Usage" with this list. I need a macro which can search the name written in Trial...
  13. J

    Finding Specific Letter and Number Strings

    Say I have these two lines in Column A: 3051S2TG4A2A11X5AWA3WK1I5A1140 3051S2LD2AA1A1030DFF71CA00 I need to be able to have a formula in Column B that Finds the letter "A" when it is followed by four numbers, and then return "A and the 4 numbers." So for the first line, the result in Column...
  14. P

    Find multiple Dates & a Number and pass result to Textbox as true/False

    Hi Guys, I am looking for VBA code to search for multiple entries and if those multiple entries are "True" then the code will pass the Answer in a Textbox as "Hired" or "Available" Basically I am trying to develop a little program for Hat Hire whereby if I enter the Date of when the customer...
  15. P

    Find multiple entries

    Hi Guys, I am looking for VBA code to search for multiple entries and if those multiple entries are "True" then the code will pass the Answer in a Textbox as "Hired" or "Available" Basically I am trying to develop a little program for Hat Hire whereby if I enter the Date of when the customer...
  16. T

    Help Populating a Table

    OK - I need help creating / populating a table. I can talk it through, but can't figure out how to work the formula... In the table below, the left half is the data I currently have. I need to wiggle it around to look like J10. Basically, I need a formula that I can plug into every cell in...
  17. I

    Find value in ROW and return value in adjacent Cell

    Hello I am having a challenge with this one and have spent over 4 hours on the net attempting to find a solution... none seem to work for me. I have column A with the company name, Column B to G are new equipment and H to AN are service. (I am not VBA Savy sorry) The challenge...
  18. K

    Find a value from a table

    Hi, i have data spread across 76Rx68C - this table is raw data with no logic to placement of values within in in another sheet i have one row of values i need to know if each of these values appear in the data spread. - a simple YES / NO would suffice - i dont need to know where exactly are...
  19. E

    Separate real name and Parent Name

    Hi Guys , I am struggling to separate this worksheet in my work place . i have thousand cell with this type and i would like to separate them Name (a cell ) Badrol Zaman bin Abdul Samad Nurhayati Sholeha binti Abdur Rahem real name ( b cell )should be : Badrol Zaman Nurhayati Sholeha...
  20. P

    Text search in Excel

    Hi Folks, I want to use Excel to perform some types of text search and do display the results as described below: For example, I have an excel table with two columns (A, and B). column A contains a list of book names, and cells in column B are synopsis of the respective books (which is a text...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top