$$Excel-Macros$$ Re: Excel Training Material (PPT)

Nice PPT. Thanks. On Wednesday, 12 June 2013 09:25:24 UTC+5:30, Prabhakar S H wrote: > > Dear Team, > > MY HR given me responsibility to give training on Excel to my Marketing > team. So can you send me the materilals on Basic & advance traning. > > I have engough experience on Excel but

$$Excel-Macros$$ Re: VLOOKUP Query

Hi Shrini, Use this formula instead => *=VLOOKUP(IFERROR(ABS(C2),C2),$H$7:$I$17,2,FALSE) * Problem: ABS formula is not for Text value so it will return #Value Solution: As you lookup value consist both number and text value, so if you want to use ABS formula than use the above formula. If you

$$Excel-Macros$$ Re: Excel sheet which shows folder name, the folder path of subfolder, the file name and file numbers

Hi Kath, Problem in For each loop, It starts with 1 row which has your header so use this for loop code instead: For Each oFldr In oFolder.SubFolders iFolder = iFolder + 1 Cells(iFolder + *1*, "A").Value = oFldr.Name Next oFldr Regards, Pawan On Wednesday, 23 December 2015 13:52:00

$$Excel-Macros$$ Re: REPLACE

Or you can use this: =SUBSTITUTE(SUBSTITUTE(A2,TRIM(MID(A2,SEARCH("Inch",A2)+5,50)),""),"Emerald","Emerald "(MID(A2,SEARCH("Inch",A2)+5,50))) On Wednesday, 23 December 2015 12:24:20 UTC+5:30, Vinod Kumar wrote: > > Dear Team, > > PFA required your help in replacing the content from last to

$$Excel-Macros$$ Re: Paragraph

Use these formula : 1st Line formula :=MID(F6,FIND("Document Pg:",F6),FIND(CHAR(10),F6)-FIND("Document Pg:",F6)) 2nd Line formula : =MID(F6,FIND("Analysis Part:",F6),FIND(CHAR(10),F6,FIND(CHAR(10),F6)+2)-FIND("Analysis Part:",F6)) 3rd Line formula :=MID(F6,FIND("Additional

$$Excel-Macros$$ Get the Data from Web

Hi All, Is there any way to Grab the data from this website => http://www.nseindia.com/live_market/dynaContent/live_watch/equities_stock_watch.htm using VBA code so that when ever I refresh the sheet it will automatically refresh according to website data. I use Data from web but it will not

$$Excel-Macros$$ Re: Excel lookup function

Can you send the sample file for reference. Regards, Pawan On Tuesday, 1 December 2015 20:53:42 UTC+5:30, Alan Walsh wrote: > > Hi All > > problem description. I have an excel sheet that i update manually. I want > to update automatically. > > Here is what I have, A list of faults in a

$$Excel-Macros$$ Re: Paragraph - Split Up - Excel

Use this formulas: =MID(F6,1,FIND(CHAR(10),F6)) =MID(F6,FIND(CHAR(10),F6)+2,FIND(CHAR(10),F6,FIND(CHAR(10),F6)+2)) =MID(F6,FIND(CHAR(10),F6,FIND(CHAR(10),F6)+2)+2,LEN(F6)) Regards, Pawan On Thursday, 17 December 2015 12:52:08 UTC+5:30, Veerappan Engineer wrote: > > Dear Experts, > > PFA the

Re: $$Excel-Macros$$ Excel Need to Assign Weekly OFF by Formula

You can also use this formula : *=COUNTIF(D3:D22,"WO") *in Monday column and drag to right. On Thursday, 10 December 2015 19:01:37 UTC+5:30, Sadiq wrote: > > Hello , > > I need put Week OFF (WO) basis of attached excel (Day wise WO count) > (Excel attached with your reference.( if change day

$$Excel-Macros$$ Re: help on find the list matches to the cell part value

You can use this formula also: *=IF(ISERROR(MATCH(MID(E2,FIND("/",E2)+1,LEN(E2))+0,$A:$A,0)),"No","Yes")* Regards, Pawan On Tuesday, 22 December 2015 17:08:03 UTC+5:30, Ganesh N wrote: > > Dear team, > > I want to find the any of the given list of value matches (part) in the > particular cell

$$Excel-Macros$$ Re: Excel lookup function

Hi Alan, Can you provide the formula which you are driving by using wildcard ("*Station 18 (Vaccum)*") but not getting solution? Note: Don't use Lookup function if your list not in ascending order. Use Vlookup function with exact match by using wildcard. Regards, Pawan On Tuesday, 1