Search results

well the Fred- The 5th and the 6th are the columns were need to place the formula!! based on HR meter difference and the 6th column is the No. of Days

what is the basic meaning of array formula ?

i hope !! HUI reads it :)

i have a database on a large scale B COLUMN L COLUMN P COLUMN R COLUMN S column Tcolumn PRODUCT CODE Date HR METER CATEGORY HR meter/differnce No. of Days APJH-1234 15/2/11 2345 COM there are to categories Com and Usm there are 800...

LUKE i really appreciate your help bro :) may GOD bless U

I would Like to 1st Thank Chandoo for providing a Paramount platform for excel help....and HUI for all the help based on my ITV project the Designing, Flow charts and all the effort and LUKE for the formulas, MACO's and concepts.....All i really would like to says the vast knowledge and skill...

is the chart area ! the camera tool is deactivated!! in others worksheets its active! well when we cursor over the bar so it shows data label so i need to de-activate that!!.. camera tool is not working my friend

sorry for the caps lock basically in office work based entry i used caps lock due to which!! i accidentally did that... Camera Tool !! how do i do that luke!... is there any ref. for it a link or a site!!...so i can get the clear understanding ? i have excel 2003!

WHEN WE MOVE THE MOUSE COERCER ON THE CHAT FLOOR SO IT SHOWS THE COMMENT BOX FLOOR SO HOW TO HIDE THAT COMMENT BOX !! OR DI ACTIVE THE COMMENT OPTION IN EXCEL 2003

THANKS LUKE ALOTTTTT

THE FORMULA IS =VLOOKUP(B2,'[FINAL-Main ITV REPORT-PART1.xls]Database'!$B$2:$I$851,2,FALSE) AND I NEED TO ADD IF(ISNA AND I AM NOT ABLE TO DO IT KINDLY HELP ME OUT PPL!!

when u are right when your code deletes the duplicates so in the linked sheet it gives ref error to avoid that if the rows should only be cleared and sorted by G (DATE) so all the cleared rows which are blank will be moves down right!! so no empties in between the data! :D

because it wont hamper the location ref in ref sheets...

Luke: Can it be modified to only clear the Duplicate data from the rows and Sort the data by G till 850!!!(Date)

hui if i used below mentioned formula's: when i add new data & clear the rows old duplicate data...NOT DELETE THEM so it does not give ref# error because the original reference cells are not deleted....and when i sort the data Date wise so the empties that i cleared are moved down.... in A2 ...

hmmmmm....I see !!..well Hui am running a macro to delete the duplicates rows from Up to down.... because if i'd go towards clearing the rows 1 by 1 that will take Hours!!... what if i use a Macro ! to clear the rows rather then deleting !! so that will not create the ref# error and then Sort...

CAN U Describe the formula so one can learn the concept and the purpose

SMART MOVE LUKE....tHUMPS UPPP

Hui well this query is basically related to the same database that you have worked on ! the important field are the remarks....Like USM should move to usm enroute, Com to commercial unt to untraceable & etc etc... so can u come up with sum formula to handle this issue !!

well i have to work in both cases right ! whether refresh the A column with =IF(Database!I2="usm",MAX(A$1:A1)+1,"") or revert back the formula at its original place!

Need to modify the macro from deleting duplicates based on 2 criteria 1st the duplicate and 2nd criteria dd/mm/yy for e.g Columns A serial B Names B C quantity D Quality E Category ....G DATE..etc etc.... Should search for duplicates in Column B & for Dates In G If found 1 Grapes 12...

well thats not possible! cause the entered data is already exists in the data but based on previous date based activity... so we entry current date data that we receive from one of the department...so we delete the previous data and keep the current and the previous could be any where... in the...

Returns a reference to a range that is a specified number of rows and columns from a cell or range of cells. The reference that is returned can be a single cell or a range of cells. You can specify the number of rows and the number of columns to be returned. what does above means in easy...

what is the concept behind using Offset !! why do we use offset ?

i am generating #ref error the transfer of data in the required sheet is perfect The automatically generated sheet from main sheet...formula as : in A2 : =IF(Database!I2="usm",MAX(A$1:A1)+1,"") in B2 : =IF(ROW()>MAX($A:$A)+1,"",OFFSET(Database!$A$1,MATCH(ROW()-1,$A:$A,0)-1,COLUMN()-2))...