Search results

Hello buddy, Sorry for my late gratitude for pointing me to right direction. Thanks anyway and i hope u both have a good day. Regards, Tiong999

Hello buddy, I use excel 2007. Yes, i want to build dependent validation list. In my case, it will more than 7 group and go further unlimited dependent validation list. Unfortunately, i have read those article but i dont find it usable for my case. I alse read some new article, maybe can use...

Hello All, Im so glad to have all expert in this forum may contributing to solved my excel problem. As the title, i want to know how maximum nested if function allowed...................is it 7? If so, how can i made formula in my dependent data validation formula which need unlimited group...

Dear Bosco, Thanks again for solution...and i learned something today from you and Peter Bartholomew. Best Regards, Tiong

Hello Dear Excell Master; May someone assist me how to extracting data record base on multiple criteria. I Found a good youtube channel which seems perfect similar issue i want to formulate, but seems dont work. Here i attach is example book record from youtube sample. I will grateful for...

Thanks for your kindness contribution. Regards, Tiong

Hello bosco, Thanks for your formula, but unfortunately i dont have FORMULATEXT function in my excel 2007 version. Regards, Tiong

Hello all, I have a tiny problem which i couldnt find the answer anywhere. Im looking formula to duplicate formula within cell reference. Cell Referrence is C9. C9=Sales!L305 Now i want to make formula within L3 L3= OFFSET(Sales!L305;0,-2) Is there a way how to duplicate only formula within...

Just notice, i havent changed formula i paste from cell b19, since i deleted 2 rows before i post new attachment. B17 =SUMPRODUCT(--($A$4:$A$6=A17);($B$4:$B$6))+SUMPRODUCT(--($A$10:$A$13=A17);($B$10:$B$13))

Helo rahul, Sorry i didnt explain it better. Here attach i update new file. Hope u can see math behind it i try to explain. Regards, Tiong

Hello all, I need someone to fresh my brain for not flowing how to formulate inventory equation base on different small unit. Lets open attach file, thanks for your guidance for me. Regards, Tiong

Hello Bosco, Interesting of your way to paste it in similar result as i expected. It work perfectly, only if i paste it special into the same G4:G31. But, unfortunately G4:G31 is source range to copy, and i will paste special to G41:G68. Notes: Example Range I41:I68, is expected result im...

Hi Chichiro, Im glad for your reply. "You'll notice some of the cells are not true blanks. You'll have to select those ranges and hit Delete to clean it up." Im noticed your statement but i dont quite understand. Im experimenting this way: * Select G3:G31 * "Go to Special" and * Check circle...

Hello all, Thanks for your time to contribute our forum. Herewith im not asking how to formulate, but how to paste non blank cell from source and paste to range target like example i attach. I appreciated for any review from all member here. Thanks all. Regards, Tiong

Hai, Your approach interesting me for a reason, but i dont familiar with your formula. Yet, it will result Static (not flexible). Lets say, i added new column. Anyhow, thank for your reviewed. Regards, Tiong

Thanks Bosco_Yip & R2C2, Your contribution really awesome for whole user. Regards, Tiong

Hello, I appreciated of your reply. But unfortunately your formula transpose whole rows to column. In plain english, my goal was to transpose B4:M4 to B13:B24 B5:M5 to B25:B36 N4:Y4 to C13:C24 N5:Y5 to C25:C36 Z4:AK4 to D13:D24 Z5:AK5 to D25:D36 et cetera et cetera the...

B13 = INDIRECT(ADDRESS(COLUMN(B4)-COLUMN($B$4)+ROW($B$4),ROW(B4)-ROW($B$4)+COLUMN($B$4))) C13 = INDIRECT(ADDRESS(COLUMN(N4)-COLUMN($N$4)+ROW($N$4);ROW(N4)-ROW($N$4)+COLUMN($N$4))) Using above formula cost my time, because i need manually modify column. Im trying to modify formula with extra...

My bad, i think i provided example not correctly ruled out. Herewith i re-attach better example. I appreciated of any review from u guys. Regards, Tiong

Hello buddy, Thanks for your review, i appreciated of any contribution. Regards, Tiong

Hello Bosco, Formula will work excellent only if Code listed in the way i propose, which i actually skim it shorter for better view of the code structure. Herewith i attach new sheet B, which i copy the real structure, and formula give me undesired result. Hope u could understand that code...

Sorry, here i attach two sample to make better comparison than file above. Regards, Tiong

Yes you got it right. Maybe i just fell asleep when copied it so i put the formula in cell C7 instead of C6. Cheers buddy...have a great day today. Regards, Tiong

Hello, I have prepared some calculation that need generate calculation from somewhere downline -Nth developed into 2 suffix, and Pass Up if any quota met. Please give a look closer to get know the rules on workbook i set. Really appreciated any contribution of u guys. Regards, Tiong

Thanks Buddy, it help me...but i give it little improvement as my intention. [C6] : =INDEX(C$5:C5,ROUNDDOWN(1+(ROWS(C$6:C6)-1)/2,0))&" "&INT(1+MOD(ROWS(C$6:C6)-1,2)) Thanks and have a nice day. Regards, Tiong