Search results

Nice work Asshu, I evaluate this function, could you please elaborate what exact row no. "0" is doing in Index function, Actually if i lookup from different cell it throw Val error. Attached is the sheet fyr.

Yes Ashhu.. Row value (City) have to match with Column (City) then Vlookup will give the result from lookup (Country). Please suggest

Hi Team, I have attached problem where lookup find 1st value from array, if i want 2 or 3.. so on value how can we do. Thank you

Hi All, Hope you are doing well, I am stuck in a problem where i have to loopkup value from sheet 2 and have to changes in sheet 1. i am using match formula but when sheet 2 lookup value is not present in sheet 1 it shows the error. Attached is the file fyr,Please clarify how to resolve...

Hi Sir, Seriously i don't know how to use range.copy method in this code, if possible please suggest what changes need to do in the code. Thank you

Hi Sir, Please find the below code, Please assist. Sub Demo() Dim arO, resAr(), i As Long, j As Long, k As Long Dim rcol As New Collection arO = Range("A2:G" & Cells(Rows.Count, 1).End(xlUp).Row).Value2 For i = 1 To UBound(arO) If InStr(arO(i, 1), ",") Then x = Split(arO(i, 1), ",")...

Hi, Could you please let me where i have to use Range.Copy.

Hi Mark, I have tried Range.copy, but not getting the result. Please suggest or have a look the code.

Hello, I have attached file where code breaks the cell in to row if symbol found in cell, but it destroy the structure of data. i want the result as per the attached.(that mean if cell have color in this case new created rows cell also have the same color) please suggest what changes are require...

Hello All, Hope you are doing well, I have the attached file where code breaks cells where "/" and "," found in cells, But if i want to break only those cells where is "/" that mean "," contains cell will remain as it is. could you please advise how to do as per attached sheet.

Yes, you are right. We can also do same from Column 2, Just one qs. what exact "SpecialCells(2, 16)" is doing ?

I have a data where if #n/a found on 2nd cell, then 1st cell value will replace the 2nd cell value. below code is working fine but whenever any blank value is in 1st cell code skip that steps and #n/a remains as it is. Please assist Sub NAFILL() For Each r In Columns(1).SpecialCells(2) If...

This one is perfect... :) Thank alot .... :)

Hi Narayan, Please have a look, You may see i want to apply split only on column "A" and "B" or any specific column. Attached is the file for your reference. Please feel free to ask me for any details.

Below code works fine when there is no Delimiters in column "C", "D" so on.. But any Delimiters come in same column it throw error. Sub Test() Dim arO, resAr(), i As Long, j As Long, k As Long, aa As Long, bb As Long Dim rcol As New Collection arO = Range("A2:G" & Cells(Rows.Count...

Hi Chihiro, Hope you are doing well, If you get time please have a look on the above problem.

Hi Chihiro, This one if perfect, Thank you. But if i add additional column like "C", which i dont want to split can we do it ? That mean i want to apply split only on column "A" and "B" or any specific column. Attached is the file for your reference.

Yah.. have used split but not meeting my exception, everything got jumbled :( anyway will try

Yes, you have used RegEx that makes little bit complicated to understand basic users, actually i have to teach to my student. will try to find another way :)

Is there any other way to write this in another simple method.

Hi, I have a data where multiples values are in single cell, i have to arrange all values separately. could you please help me out. Your suggestion is highly appreciated.