Hi Everyone,
Please provide a formulate to separate these in three columns or whatever is the best way to filter it out pls.
Column A2 is filled with ABC-000002
Column A3 is filled with ABC-000002-001
So, basically, I want to filter out these two things, so, i was thinking to use text to column...
Dear all,
I need to pull Cummulative Total from Daywise Sheet based on the Location code criteria and from a specific Date Range mentioned in F3 and G3 Cells.
File Attached.
Kindly help me on this.
Regards,
Deepak
And also Can I get results in cells like: "1 <150 and 2 >200"
Because with the total figure it would again confusing that how many less than and how many more than.
Regards,
Hello Everyone & Peter,
I don't whether I should write in this query or not because this is related to this one only. I just need to add one more condition to it, thats why thought to ask here.
What I need is to countifs Column A, B, C & D are same and Col E should be <= 150 & >200.
Please...
Thank you so much Peter...This is exactly I was looking for.....But how this is working with the column heads only ? If you could clear a bit.
Thank you vletm and Marc for your support too.
Regards,
Hi vletm, Thanks for your time.
I mean actualy If Product Name, Thickness, Length and Witdth are same AND Pcs are less than 150 then I need to count that row with rest of the rows where Pcs are less than 150.
I think VBA can work in this way Because what we can do is :-
It should store the...
Thank you so so much Hui !! That's what exactly I was looking for. You have also changed the lookup column i.e. "A", Thats very right because I was using cells.find which could find anywhere on sheet, But you did exactly right to make it search in A Col. only.
Thank you once again Dear !!!
Hi Hui, Thanks for your time but Actually this is my just beginning in VBA & also not clear with Looping concepts, That's don't know how to do it.
If anyone ELSE could do it please.
Regards,
Hi Everyone,
I need to apply a loop for my attached file Code. Please see how can I do this.
Actually I need to find "Agent:-" in column "A" then again find this in same row then copy all the rows inbetween those two FOUND Results and paste in diff file and again start the same concept from...
That was Amazing Vletm! Thank you for your effort made. However, If you could review it again please Because It's storing the first result Only, which it is founding as per the criteria and showing that SAME result for other match found records OR Duplicate records.
Please see the red marked...
Hi All,
Please help to resolve this.
I Need result on G column FROM H column of Database sheet as per the above conditions, If any cell in K2:K6 gets equal to "Y", then it should search as per that criteria only.
Two conditions can be the be same, that can be any out of 5, Need to search as...
Yes, you are right sir, Could you please remove the third condition i.e. Date column from these calcs. I have tried it but not successful.
Need to remove it because date format is not correct actually.
Regards,
Hi Vletm, Yes I tried this. your CODE is absolutely fine, no issues with that. The only thing which I am facing is the Eff. Date issue which is from my side. When compiling the data on Data Sheet, the format which is pasting in Col. 16 is in double format, in some cells its in mm/dd/yyyy format...
So sorry for late reply vletm, Thank you for your help! This is good though.
But Can I get a simple SIMFS formula to determine the things... I have the formula attached in sheet but need to consolidate "All" conditions also for all three fields i.e. "B1", "D1" & "H1".
Thanks & Regards,
Hi Everyone,
I got stuck in-between, would need your help. Actually, I have Three Drop downs, I after choosing them the data should display in Chart.
Please see the attached sheet for more clearance.
1 If B1 = "All" & E1 = "All" - Then chart should reflect all values as per the Range i.e. A7...