Search results

Well so if there is no Meter reading so we need to place 0 rite !!...so match formula could cover it !!.. and wont generate #N/A error ! rite

Luke is the TRUE EXCEL NINJA...:)...my blessings are always by Luke's side like a guardian angel :)... THanks alotttttttttt for all your HELP....!!..and BEST of LUCK for your BRIGHT Future

still still showing the #N/A error :((

rite !!...gr8 advice...bro....so i'll extend the range according to the data.... well need a favour... luke if i want to get good command over arry formula's so from were should i start...!!..and learn

Luke buddy thanks for your fast reply...well Can we turn range from b3:b77 to B:B ?

luke buddy the formula is working perfectly ...but Its showing #N/A is the current genset no. does not have the value!...

lOLS !! its ok buddy pls dont apologies....pls after all u are helping me out:)...am sorry that i got u all confused bro.... well yes !... its a Meter reading based on the running of the genset... that it has been running and start for xyz hrs...during the travailing for A destination to B...

we can change Range to A : A rite and soo on!..

Luke my friend ....U have seen the workbook right!..well in the "Database" sheet ...the Result should reflect infront of the concerned cell!... for e.g. abc is the Genset code S.no..Genset....Date......HR Meter.....Hr Meter Difference 1......abc......1/1/11......200.........300-200 = 100...

Thanks for Jumping in Luke :)...well what are the alternative methods?...well remember the project u helped me with is sensitive data!..and need few ppl to access it others only view it!..so no 1 can mess or take the codings from it!...my Operations manager told me to get Login password in...

after all i managed to unhide the 2 sheets:D changed xlVeryHidden to True :)...

how to i reply there!...am not able to see the reply tab!... and i have downloaded the excel file..but!,,, there are 2 sheets hidden and i want to unhide them!..but not able to do so!..

has the complete template! okay..well am already registered :)...so let me check the template out

template..that shows how any process is gone!.....well I hope sum1 helps me out!..with creating login and password

Kindly check the link, if any question! or if u think am not that clear so do ask :)

well i need to clearly understand till this part after that i'd move onwards to understand it perfectly...so that i can understand how to join two formula's or more formulas togehter...

well asa @ If your Criteria are all in a range of cells, such as F22:I22, I think you could simplify it to: =SUMPRODUCT(--($A$2:$A$10=$F22:$I22))>0 {=SUM(--($A$2:$A$10=$F22:$I22))>0} U have added two formula's together in above mentioned formula right ! sumproduct & Sum rite? well...

THe link is about Applying Password protection!! well i know how to apply password protection! well i want to create login ids and passwords!...so only specific users can open the workbooks simple!...

all that went over my head :(( is there any template for it ? am not good with excel :((

here is the link : https://docs.google.com/spreadsheet/ccc?key=0Ah3qQ3ZqPOsPdDhmcXptbUNET3NIcW9nMEsyMWFkVnc&hl=en_GB well the report should provide the results that viewer can check the Hr meter against selected multiple gensets... its a sample report!...if you want to modify it sure go...

buddy HUI need your help again in TOPIC Excel Formula

i had the idea !! that Hui must be on vacations :)....thanks again HUi and LUKE :)...my blessings are always by your side!

is there any possibility of creating login and password for the users? so they can access the worksheet?

and so On.. if apjh-1234 was again sold on 5 September 11 and the entry is place in (row no. 2000) with the HR meter 1200 (could be any)..the difference of current subtract previous should reflect infront of the previous one like 1200-550.1 = 649.9 in front of the previous one!...the process...

well there are 800 different product codes... in the inventory sheet1 and in database sheet we place activity related to the product for e.g the product entry was place in row no. 20 ( could be in any row)apjh-1234 was sold on the date 15th January 11 HR meter 200 is the no. of how may were...