Search results

JB we are here to help one another! not to create a bad influence or taunt !.. sorry if you think my words are rude :) kyle you earn my gratitude & respect... cause i really respect those who have vast treasure of knowledge and help ppl as well... kyle do you have e-books or! how did you...

awsomeeeeeeeeeeee.........kyle You really have Out Of the Box Thinking!!.. am impressed !..could you tell me the secrect to your knowledge bro!!

dont use that much Brains !!...JB sometimes it can lead to over confidence no hard feelings bro.. i has download the file!... when it was uploaded in docs.google.. UNDERSTOOD!!

well we cannot get access because of our office policies

i know what macro is..friend...let me upload the file..!! so u can look into it!... am not that good with excel... https://docs.google.com/spreadsheet/ccc?key=0Ah3qQ3ZqPOsPdDYxdG5GWkV6eE1nSnF3bHpsd3dDcWc#gid=0

i cannot download the file untill its on doc.google :(( internet restrictions

in this case i wont be able to find out whether column a b or c has the typing mistake!..cause my data can more then 4000 entries...

I have one workbook (Excel 2007) with 2 sheets. Sheet-1 contains 4 columns like the following: Excel Sheet 1 COLUMN 1 COLUMN 2 COLUMN 3 COLUMN 4 1005 10 Sam Royal Blue 1005 20 Peter Navy Blue 1006 50 Mary Rose 1100 40 Sonam Green 1156 80 Rashmi Pink And the Sheet -2 also contains 4...

the problem is still not solved :((

I really appreciate your effort.. kyle.. but the Perfect Match should be based on 1 sheet dynamic search!.... for e.g in sheet 1 if the data is in row 1 and in sheet 2 the same data is in row 100.. or any where in between A:A, B:b & C:C so it should says Perfect Match!... because untill an...

I really appreciate your effort.. kyle.. but the Perfect Match should be based on 1 sheet dynamic search!.... for e.g in sheet 1 if the data is in row 1 and in sheet 2 the same data is in row 100.. or any where in between A:A, B:b & C:C so it should says Perfect Match!... because untill an...

Friends from Office i cannot access Storage sites like Skydrive. :(... can only use google doc... can u simply paste the Formula in here!!

well its ok i understand :) and no need of saying sorry at all :)...

1. yes 2. yes our data is in 1 sheet 3. yes in 2 sheet & then i place Our in is ABC & Terminals data in DEF..so DEF shall check A:A B:B & C:C 4. Yes we need to compare Terminals data with Our data.exactly Can differ in any Items.. 5. Yes Container should match each other destination with...

Let me describe it clearly my friend.... I have Data based On three columns A is Container No. B=Destination C Quantity of packages and Same Data we receive From the Terminal So i place my Data in the data i receive from the terminal in 1 sheet and Check either container No. aphu-1234567 for...

This formula check data in C1,D1 in A:A & B:B could it be extended to check of D1,E1 & F1 in A:A, B:B & C:C ? formula is =IF(C2="", "", IF(D2=INDEX(B$2:B$65536, MATCH(C2,A$2:A$65536, 0)), "", "mismatch"))

HR meter Difference is handled by the macro ?

no need of saying sorry bro i understand...and appreciate your help alloooottt :)

bro like i says earlier i cannot access any site other then google doc....Internet office policies :((

GCEG-1155; Activity...in Column H in database sheet.. reflects the difference of days for eg.. 1 activity : GCEG-1155.....02/03/2011......result > 5 is the difference b/w 1 & 2 activity 2 activity : GCEG-1155.....7/3/2011....... result > 5 is the difference b/w 2 & 3 activity 3 activity ...

there are 800 product codes...and i have a inventory on the sheet1 and sheet2 is the database Okay... for e.g. if apjh-1234 dated 15th jan, 11 is on the 1 row with hr meter 200 and the same product code comes randomly in the list could be anywhere in the list could be on the 2nd row or the...

in AVG. DAYS? column?~~!!~~ well i have restricted internet connection in my office so i cannot download it from Skydrive... can u load it on google doc!!

the link https://docs.google.com/spreadsheet/ccc?key=0Ah3qQ3ZqPOsPdDRZMzlwSnpNVndKOWhjMHFxZTlHbkE i have added a note as well... thank u :)

should i attach the worksheet?!!

Can I USe this array for Dynamic Range such as C:C & A:A?? Shows an error of #N/A as i have changed the formula to {=LARGE(((DATABASE!$C$3:$C$800)*(--($B$3:$B$749=B3))),3)} AND SAME GOES FOR {=LARGE(((DATABASE!$C$2:$C$800)*(--($B$3:$B$749="AMLG122351"))),3)} If the range is not Same for...