$$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 sheet which shows folder name, the folder path of subfolder, the file name and file numbers

try this http://www.excelvbamacros.in/2012/05/file-and-folder-series-get-names-of-all_26.html see if it helps On Wed, Dec 23, 2015 at 1:51 PM, Katherine Loo wrote: > Dear all, > > I would like to create an excel sheet which shows folder name, the folder > path of

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$$ Remove all existing macros on certain date

Hi Expert, Can i get a macro which can remove all existing macros from a file on certain date.. Kindly share the same. Thanks. Regards Pravin Gunjal -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this

$$Excel-Macros$$ Need Help on attached sheet

Dear Team, Please find the attached excel sheet in which the raw data is sheet 1 and the required output is in Sheet 2. It would be very helpful if you help me on this. Regards -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official

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

Hi Pawan, Thanks a lot for your help. My issue has been fixed. On Wednesday, 23 December 2015 19:58:14 UTC+8, Pawan Yadav wrote: > > > 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

Fwd: $$Excel-Macros$$ Need Help on attached sheet

Use this : Sub Data_Formatting() Dim rw As Long For rw = 17 To ActiveSheet.UsedRange.Rows.Count Step 6 With Worksheets("Required").Range("B" & Rows.Count).End(xlUp) .Offset(1, 0).Value = Range("D" & rw).Value .Offset(1, 1).Value = Range("D" & rw).Offset(3).Value

$$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

Re: $$Excel-Macros$$ VLOOKUP Query

Dear Mandeep Sorry for too delay reply .Actually I was on different project and now back to the home. Please find attached file. Marked in yellow is not giving results as I am using Vlookup with ABS function ,marked in brown gives results I am using Vlookup without ABS function. If I used the

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

Dear all, I would like to create an excel sheet which shows folder name, the folder path of subfolder, the file name in the subfolder and the updated revision numbers. I've written some codes and it can only shows the folder name and one of the folder name isn't appeared in the excel list. It