excel & lookup & search

  1. S

    How to Distribute Data in a column/s to other sheets in terms of certain Cell Reference

    Dears, As per discussion on Youtube Channel, please find hereinafter the spreadsheet to help in find out a method to handle the DATA redistribution over other sheets. How to distribute DATA in Sheets (INPUT1 + INPUT2) based on Columns J " CODER" over the the other sub sheets {LELA, AMAL, BURAQ...
  2. P

    VBA: Formating specific text sections of a cell based on conditions.

    Hello, first post here :) I have the following problem: -I have extensive lists of sentences in Excel, in which there are words ending and beginning with <strong></strong>. -Every day new words appear having these <strong></strong> remarks. -There is the need of creating a macro to automatize...
  3. E

    Formula

    Hello guys, I have this case below and my aim is to fill up column H for subtasks. Needed result is that all sub-tasks below story should have the same fix version value than their story. Can you please share with me the right formula to achieve this? Thanks in advance.
  4. R

    Match rows for value in specific columns and paste matched/unmatched rows in new sheet

    I got data in sheet1 and sheet2, which i want to copy and paste in sheet3. That is already done. So next i want to match rows, by checking column C, D, E, H and I. The C and H column value is integer and the rest is text/strings. If two rows match, then i want to copy and paste one of the lines...
  5. K

    #Found Duplicate & set Hyphen Symbol - via Formula based

    I Need Hyphen " - " Symbol via Formula, Unique Number based Condition , Found Duplicate & set Hyphen Symbol - in D Coloumn
  6. R

    Make data input from multiple workbooks in one master workbook

    Hello, i would like to make a data input from two workbooks that is in the same path. The data input should be in the master workbook from those two files. The first sheet in the master workbook should just be empty as im going to make macro run buttons for later purpose. The data from the first...
  7. R

    Insert data from two worksheets into master workbook and match values

    Hello everyone I would love some help to develop some VBA code. But im very new to VBA. Hope someone can help me with it, and i know its a lot to implement. So its for private purpose and a "just for fun project". The project is that i want to two files in a path that i want to match with...
  8. L

    Read a specific 18 numbers.

    I have a excel with a line with multiples numbers in pairs of 18 and a ",(space)" then the next 18 numbers like this "869353363609899039, 869353363609899040, 869353363609899044, 869353363677020214, 869353363769290771, 869353363807010852, 869353363815411754, 869353363815411756...
  9. K

    #Get data "Sheet 1" to "Sheet 2" in excel ( Check in Image , Follow Condition )

    #Get data "Sheet 1" to "Sheet 2" in excel ( Check in Image , Sheet 1 many Spaces in there , So i Need "invoice Number list" on Sheet 2 (Auto Generated) how to possible get data as a list format, NOTE: SHEET 1 : *** So many Space in there*** SHEET 2...
  10. K

    Autogenerate serial number according cell reference Number ????

    Autogenerate serial number according cell reference Number ???? I have try cell Reference : A2 =11 i try cell reference A2 to B3 , problem is B3 Cell value According Auto generate serial Number.
  11. J

    VBA to extract row data to sheet and update data set

    Hello All, I created a Excel Workbook to enter and track quotes for something I am working on.. It works good to enter data, calculate additional charges ect and hold the quotes in a seperate sheet. The sheet has a macro to copy from the input sheet to a sheet called database to hold all of...
  12. K

    How to remove unuse area in classics pivot table ?????

    i need only one Column , how to remove unuse area in classics pivot table ????? Show me how to delete empty column formatting
  13. K

    How to show selected menu in slicer to other cell ??? (Like a Refrence Indication)

    @ How to show selected menu in slicer to other cell ??? (Like a Reference Indication) in pivot table ???? I have Try selection in slicer information reference to other cell , Above image like this yellow Highlight cell this reference
  14. K

    How to match Same number via join data ( As per Image Below)

    How to match Same number via join data NOTE: Not use this formula ( =+C3&" "&D3&" / "&C5&" "&D5&" / "&C6&" "&D6) WE NEED THIS PERFECT FORMULA IN THIS QUERY
  15. K

    How to Highlight Cell After match Both data ???

  16. K

    Change Font Color Black to White After Found " 0" Value In E Column , And may be I hope Hide row According Zero value. ???

    i was try "Change Font Color Black to White After Found " 0" Value In E Column , And may be I hope Hide row According Zero value. ???" how to possible Conditional Formatting ????
  17. K

    Make One Dropdownlist , Including all table Column Cell Details Show without Dependent Dropdownlist ?

    @ How to make One Dropdownlist , Including all table Column Cell Details Show ???? without Dependent Dropdownlist ??? How to show dropdownlist using different -different Columns data , And Add Included Single Dropdownlist ************************************************NOT USE DEPENDENT...
  18. kelly mort

    (VBA) Code Amendment Needed To Filter Data From A Worksheet Into A Combobox

    The code below here was written for me by @Fluff some time ago. It's a very wonderful code and I love it. I have added 2 more comboboxes to use as the criteria for doing my filtering but I am stacked with how to get it tweaked. The new comboboxes are: ComboBox3, which will check column Y and...
  19. M

    Search/find function for an entire column

    Hi, I have this function that searches column A for words that I listed in column D and returns "found" or "not found". In the formula below, I only have to search for 4 words in column A so the formula refers to $D$4:$D$8. =IF(SUMPRODUCT(--ISNUMBER(SEARCH($D$4:$D$8,A5)))>0, "found", "not...
  20. K

    How to make Automatic serial number with text ????

    How to make Automatic serial number with text ???? Basic = A1+1 =2 Next level : 1) India Combination with text Kindly Help me.....

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