Search results

Hello Debraj, Please use my name as GN0001. I have been thinking on what you say. I am not even able to build what have rebuilt on the previous post. Hello Narayan, I will upload the file, Can you explain what you want your CF to do? I want my range turn to green if the value of the cell...

Hello all, I am doing a conditional formatting on a column and I want to use this option: Use formula to determine which cells to format, this option doesn't work at all, (The other option: format only cells that contain works partially!). Can anybody help me on this, please? Thanks, GN0001

Hello Vishal, My world will be changed if I understand this post. First I need to understand the LookUp function: is this our array? Wells Fargo Bank of Commercial SCC2 AB 1 Project Glassdoor are these our lookup values? Wells Bank AB Project Client Site...

------------------------ Hello Debraj, The function posted by Vishal worked. I can't understand some part of that? What does 2 and 1 refer to in (2,1/ISNUMBER(SEA? Because once I scan the function the function comes to lookup(2,1). Also in description of the function says that LookUp provides...

------------------------------------------------- Hello Vishal, Thank you for the great answer. But a couple of things: 1-I tried search function, it always bring back 1, why is the reason? 2-Lookup(2,1), how does it know to bring back Wells Fargo (the correct texts)? What 2 and 1 refer to? I...

Hello Debraj, I have posted the file. Thanks, GN0001

Hello Vishal, This worked,however I couldn't find more than 5 matches, Do you think of some other way? Also, I didn't copy and paste the function, the values are displayed in the range. Can array functions paste able? Or do they get the values to be displayed on the range? Please advise me...

Hello Debraj, I have thought times and time that how I can pay this goodness back. What team members have been doing here is great and I can't find any word to appreciate all this. But my knowledge is not that much to help others, I don't want to help a member in an inadequate way and misguide...

Hello All, I have two lists, I need to match these two lists through their texts? is this possible? If one part of text is found in another text , we need to take these two cells as matching values. The reason for doing this is the first list is mapping to some ids and the second list is...

Narayan, I understood. :awesome: I am going to practice it a lot, may be I become:awesome: GN0001

Hello Narayan, Thank you for your patience with me, I am working on the function in column 1 and Row 8. I am in Row 8 and I have values in row 8, I get the corresponding row number + 1%% I understand it returns the project number, since 8.0001 is translated R8C1 (with substitute functions and...

Hello Narayan, You say this formula: SMALL(IF('C:\Users\GN0001\Downloads\TimeSheet.xlsx'!Data<>"",ROW('C:\Users\GN0001\Downloads\TimeSheet.xlsx'!Data)+1%%) return the corresponding row number + 1%%. This is correct, then why do you use Small function...

Naryan, I came to work on the function to learn it. I faced up with this problem: The destination workbook was not showing any value, while time sheet workbook was open, A dialog box was being shown up, asking for update Then the message was: "it is not connecting to server....." I came back to...

Hello Narayan, I left the false or True part of the function here, and I what I select is in range, and my function worked today. I appreciate for mentioning to me though. I don't sort my range and I always set the function to False. This shouldn't bring back the wrong result, right? Many, many...

Hello Narayan, I understood. Thank you very much.:)

No, it was not. Thank you very much. GN0001

Hello Narayan, It worked today, It was: =VLookUP($A$259, $A$12:$A40,13)

Narayan, Let me try it, Please. Thanks,:) GN0001

Narayan, I understand what code does. But I have problem with blue colored font, what does the blue part do? Set rng = Worksheets("Sheet2").Range("A1" & ":" & "A" & Worksheets("Sheet2").Range("A" & Rows.Count).End(xlUp).Row)

Narayan, I keep both of them open, still, I get what you see in the screen shot when I double click on the cell. Thanks, GN0001

Narayan, Please give me some time to think about it. Why when I click on the cell to see the formula in the cell, it gives me open dialog box? Regards, GN0001

Hello Team, I am using VLookUp function and each time I have to change the source data. but when I plug in the new data (copy the new data into the sheet from which VLOOKUP function brings back the value), the VLookUp doesn't show the result and I have to re-enter the funtion to be able to pick...

Hello Narayan, I hope you are doing fine. Thank you for this interesting function. I have scanned the formula Does the Small function returns the smallest number in an array? Or does that return the smallest nth position in an array? What does this function return? SMALL({6, 23, 5, 2.3}, 2)...

I think that's it, But let me try first and go to bigger rows and I will let let you know. Also, would you please tell me what you have done, step by step, then I will use evaluate formula to get a hang of it. Is this an array function? What are the percentage signs % you have put in the...

Narayank, Yes, that's it, and it is not urgent at all. Please take your time. It was urgent, but it is not any longer. I appreciate your time that you spend on this, I also need this to be taken care of without any code if it is possible. Because I don't know VBA. Thank you for the help and...