value extraction

  1. L

    Search field - to select best fit, from output value

    Hi All I am looking for a simple bit of code to seach column D for a name and select the next cell in column E. The data sould be validated so there are no duplicates, but the list will end up in excess of 1000 names so I would like a button at the top to prompt for a name, then auto...
    • LORDMARKS
    • Thread
    • search a file search a range search and value extraction vba & excel
    • Replies: 0
    • Forum: Excel Questions
  2. H

    1 value to be picked out of 3 cells

    3 cells generates 1 or 0; 3 or 4; 5 or 6. Answer required in 4th cell based on the 3 cell values ...please bear with me. Ex: U8=1/0 ; Y8=3/4; Z8=5/6 Answer (in cell AA8)= 1 (if U8 has generated 1) AA8=0 (if U8 has generated 0) AA8=3 (if Y8 has generated 3) AA8=4 (if Y8 has generated 4) AA8=5...
  3. A

    Please help to solve this

    Hi I have a repetitive task that i am trying to slove by a macro. I have a cell with a number - lets say cell N4 = 5782.3 Now i would like to change the B4 Cell content to =IF($K4<>0,5728.3,0) How do i do it? I have tried the following: Dim a As Double a = ActiveCell.Value...

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
Back
Top