Make a little changes in your formula as mention below, then lookup on that
value.
=--MID(A9,FIND(1,A9,1),6)
On Sat, Jun 13, 2015 at 1:07 PM, Shrinivas Shevde
wrote:
>
> Dear All
>
> I have a text in Column A4 ,I am extracting a number from that text in
> colum B4,using outcome of I want to use
Hi Kumar,
You can use below vba code to get contractor details simply by
entering Contractor Unique No and the filtered details will be saved
to respected contractor sheets.
Sub AutofilterExample()
Dim Criteria As Integer
'Enter "Contractor Unique No" to get respected contractor details
C
Hello Mr.Kumar
You can get same output by pivot table, see the attached file.
On Sat, Jun 13, 2015 at 3:37 PM, Kumar Bhanushali <
kumar.bhanush...@pmcprojects.com> wrote:
>
> *Dear Sir,*
>
> I had attached a file which contains Daily Report sheet, I am updating
> this sheet daily. This sheet cont
Dear Sir,
I had attached a file which contains Daily Report sheet, I am updating
this sheet daily. This sheet contains 7 nos of contractor.
>From this sheet, I have to separate data, contractor wise.
Please help
Regards,
Kumar Bhanushali
DISCLAIMER
The information contained in this e-mail incl
Dear All
I have a text in Column A4 ,I am extracting a number from that text in
colum B4,using outcome of I want to use Vlookup but its not successful.
Same Out put I entered by hand in the column then I get desire result.
To entered manually its take lot of time I have more than 1000 data.
Please