Search results

Narayan, Thanks a lot for all this. GN0001

I have a VBA code to trim the value in the cell: Function ToNum(X as Variant) As String Dim A as String A=Trim(str(x)) ToNum = A End Function I inserted this code on the code sheet of sheet 1 and I also inserted a module and write the code there. I can't see the code in the Macro Dialog...

Vishal, Thank you for all these answers. I understand it now, but I need to practice more to be able to apply it in other places, good luck on your way, GN0001

Hello Debraj, I have 6000 rows, I have 350 unique Project names and I have unique 120 Project Managers, and I have 16 unique dates. These 6000 rows contains different combinations of project managers and project names and dates. How can I design the data that I can capture all the various...

Hello Narayan and DEB, Ok, I realized why the formula is not working, The SumProduct and SumIfs formula that I entered were correct. I didn't map the correct cells to each other. These are my columns: EmployeeName ProjectName Date Amount George...

The data belongs to a company. Let me see what I can do, Anyway, before I go to bed, I did the function one more time, and it didn't work, this is the function: =SUMPRODUCT((A!$A$2:$A$6569=B!$A2)*(A!$C$2:$C$6569=B!$C2)*(A!$E$2:$E$6569=B!$F$1)*A!$G$2:$G$6569) Try to change the data and sent it...

I have a column that is contains project name 6569 rows, but only 180 of them is unique and I have employees that has 6569 rows, but only 280 of them is unique and I have a column date that has 6569 rows and contains values as Apr-01-2014, Apr-07-2014, Apr-014-2014 till the end of May. I have...

Hello Narayan and DEB, I have done exactly what you have done, but it doesn't bring back the result, I can't tell you how much time I have spent on it, the whole afternoon today, right now it is 12:18 a.m. and all Friday afternoon. Eventually I took it to Access to group and summarize it. I did...

Hello team, I have put a sumproduct function to summarize the data. How can I put the data/ ranges in the spread sheet to bring every thing. This is my range: Name Project Name Date Value SumProducts returns George A First Week...

Hello Somendra, Let me do it multiple times and then get back to you. Thank you for all your concern, GN0001

Somendra, Your conditional formatting works perfect. :) You are right.... GN0001

Somendra, I have uploaded these files in the beginning of this thread, do you think CF in them are correct? Please advise me. Thx, GN0001

Somendra, You are right. Would you please upload the file one more time? Thanks, GN0001

Hello bobhc, Then, if it is the case, it is correct. I must have changed during working with it. It seems to me that even the screenshot shows cell E5, but anyway, I don't have time to look at the file one more time. He is an excel Ninja, he is probably right. Thanks, GN0001

bobhc, If you are referring to this file Uploaed_2014-5-19_13-3-5, the cell E5 is highlighted. Regardless if it is highlighted or not, if we have a range of incremental numbers from 1-16 in a range of E1 to E16 and if we say highlight where E4>=$E$8, while E4 is equal to 4 and E8 is equal to 8...

bobhc, Then I don't understand the meaning and functionality of CF. In E5: E5 is not bigger or Equal to E8? why should it be high lighted? Please remember I can't understand it, I am not just arguing with anybody? Regards, GN0001

If we have two arrays such as {1,2,3,4} and another array as this {4,5,6,1} If we are going to compare these two arrays, is this how the arrays are compared against each other? 1 is bumped against 4, 5, 6, 1 Then 2 is bumped against 4,5,6,7 Then 3 is bumped against 4,5,6,7 Please advise me...

Ok Hello bobhc, Then E4 is not >= $E$8, why cell E5 is high lighted? I said I think and I never every say never. From what I have understood from conditional formatting, this can't be correct, however I might be wrong. Thanks, GN0001

Dear Debraj, Would you be so nice as to tell me, what is the result of this function? What does this lookup function return? =LOOKUP(C2,{0,"A","B","C","D","E","F","G","H","I","K","X","Z"}, {0,"1","2","3","4","5","6","7","8","9","10","12","1"})? Also, the function provides backward...

Hello Vishal, I understand this better now, certainly. You have noted: Pls note: "Looking up 2 in that will return the position of the last "1". does this refer to this part? LOOKUP(n,Ref) will all return the last numerical value from Ref when n is a number that cannot occur in Ref...

Somendra, Your conditional formatting is not correct. Because your rule says =E4>= $E$8 And when you look into cell E5, we can see that the cell E5 is formatted, which is not correct. This is what I think, Regards, GN0001

Hello Debraj, That makes sense, GN0001

Hello NARYANK991, After spending a lot of time on it, I think, I might get hang of it. I think we should set our formula to a constant rather than to a cell reference. Set the function to a cell reference doesn't bring back the correct result all the time. (this is what I think). Regardless of...

Hell Debraj, Thank you for the help. I have been working on it and it gets clear and clear for me. GN0001

Thank you for your time to respond to this post. Thank you for giving this update to me. It all worked. GN0001