Excel experts - Question on formulas... Chalanachithram.com | Topics | Search
Hide Clipart | Log Out | Register | Edit Profile

Last 30 mins | 1 | 2 | 4 hours     Last 1 | 7 Days

Chalanachithram.com DB » TF Industry related » Archive through June 23, 2011 » Excel experts - Question on formulas « Previous Next »

Author Message
Top of pagePrevious messageNext messageBottom of page Link to this message

Rajusk
Hero
Username: Rajusk

Post Number: 13734
Registered: 02-2008
Posted From: 192.234.99.10

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, June 23, 2011 - 04:06 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Idle_yzag:

nuv kuda ragging start sesava patelaaa?



DB lo antha ayo mayam thammud..

evaru evarni ae vishayam lo ragging sesthunnaro ardham kaadu..atla flow lo post vesukontoo veltha kabatti naaku anthakante gurthu undadu
Top of pagePrevious messageNext messageBottom of page Link to this message

Idle_yzag
Legend
Username: Idle_yzag

Post Number: 31469
Registered: 02-2008
Posted From: 198.80.144.187

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, June 23, 2011 - 04:02 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Rajusk:

nuvve emo Boston Birla

annai sachin, KD, secondcup kamedy chestharu, vallu doralu, nen paysek rakapothe next month handsup

nuv kuda ragging start sesava patelaaa?
RahulGandhi/JP/Chiru
Top of pagePrevious messageNext messageBottom of page Link to this message

Rajusk
Hero
Username: Rajusk

Post Number: 13732
Registered: 02-2008
Posted From: 192.234.99.10

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, June 23, 2011 - 04:00 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Idle_yzag:

vammooo 6 digit eppudu susthanooo entooo



Thammud,

nuvve emo Boston Birla vi andaru septhuntaru..nuvvu emo six figures aa antavu..
Top of pagePrevious messageNext messageBottom of page Link to this message

Idle_yzag
Legend
Username: Idle_yzag

Post Number: 31468
Registered: 02-2008
Posted From: 198.80.144.187

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, June 23, 2011 - 03:59 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Kdnumber1:

Excel lo pani sesina daanike



analysis yekkuv vuntundhi le annai, 200k na? vammooo 6 digit eppudu susthanooo entooo
RahulGandhi/JP/Chiru
Top of pagePrevious messageNext messageBottom of page Link to this message

Kdnumber1
Side Hero
Username: Kdnumber1

Post Number: 8134
Registered: 02-2009
Posted From: 216.1.5.66

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, June 23, 2011 - 03:56 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Idle_yzag:

Excel



Excel lo pani sesina daanike 200K Dtunnavante...nuvvuu samnya nahi vuncle
Top of pagePrevious messageNext messageBottom of page Link to this message

Scallion
Side Hero
Username: Scallion

Post Number: 8354
Registered: 05-2009
Posted From: 206.123.17.17

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, June 23, 2011 - 03:55 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Idle_yzag:

we are not looking for any value anna we are trying to find min of array



Got it
Jai NTR, Jai Jai TDP
Top of pagePrevious messageNext messageBottom of page Link to this message

Idle_yzag
Legend
Username: Idle_yzag

Post Number: 31467
Registered: 02-2008
Posted From: 198.80.144.187

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, June 23, 2011 - 03:54 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Scallion:

=VLOOKUP(B2,'TAb Name'!A1:AX,2,FALSE) try this



we are not looking for any value anna we are trying to find min of array, array value will be variable
RahulGandhi/JP/Chiru
Top of pagePrevious messageNext messageBottom of page Link to this message

Scallion
Side Hero
Username: Scallion

Post Number: 8353
Registered: 05-2009
Posted From: 206.123.17.17

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, June 23, 2011 - 03:51 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Idle_yzag:



VLOOKUP kooda vaada vachu

=VLOOKUP(B2,'TAb Name'!A1:AX,2,FALSE) try this
Jai NTR, Jai Jai TDP
Top of pagePrevious messageNext messageBottom of page Link to this message

Risingstar
Megastar
Username: Risingstar

Post Number: 22903
Registered: 08-2008
Posted From: 76.99.86.64

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, June 23, 2011 - 03:47 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
excel expert aaa
Top of pagePrevious messageNext messageBottom of page Link to this message

Idle_yzag
Legend
Username: Idle_yzag

Post Number: 31466
Registered: 02-2008
Posted From: 198.80.144.187

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, June 23, 2011 - 03:45 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Jp_rocks:

I got annai here is how we do

=MIN(INDIRECT("A1:A"&B1))
RahulGandhi/JP/Chiru
Top of pagePrevious messageNext messageBottom of page Link to this message

Jp_rocks
Hero
Username: Jp_rocks

Post Number: 10892
Registered: 06-2009
Posted From: 167.83.101.22

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, June 23, 2011 - 03:41 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Idle_yzag:

yes

did u try using concatenate function to concatenate A and the value(B1)??
also, is it always value(B1)?? stupid Q, but cheppu nevertheless
Top of pagePrevious messageNext messageBottom of page Link to this message

Idle_yzag
Legend
Username: Idle_yzag

Post Number: 31465
Registered: 02-2008
Posted From: 198.80.144.187

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, June 23, 2011 - 03:35 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Jp_rocks:

is that ur req??

yes
RahulGandhi/JP/Chiru
Top of pagePrevious messageNext messageBottom of page Link to this message

Jp_rocks
Hero
Username: Jp_rocks

Post Number: 10891
Registered: 06-2009
Posted From: 167.83.101.22

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, June 23, 2011 - 03:33 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
req clear ga ledu idly..

A1 to Ax range lo min value kavali..x is a variable, the value of which is value(B1)

is that ur req??
Top of pagePrevious messageNext messageBottom of page Link to this message

Idle_yzag
Legend
Username: Idle_yzag

Post Number: 31464
Registered: 02-2008
Posted From: 198.80.144.187

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, June 23, 2011 - 03:30 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Goonda:

comma pettu

RahulGandhi/JP/Chiru
Top of pagePrevious messageNext messageBottom of page Link to this message

Goonda
Hero
Username: Goonda

Post Number: 15098
Registered: 02-2007
Posted From: 199.82.243.104

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, June 23, 2011 - 03:29 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
Idle_yzag:

comma pettu
Top of pagePrevious messageNext messageBottom of page Link to this message

Idle_yzag
Legend
Username: Idle_yzag

Post Number: 31462
Registered: 02-2008
Posted From: 198.80.144.187

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, June 23, 2011 - 03:24 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)
= Min(A1:AX)

X should be value from B1

how do I do this?
RahulGandhi/JP/Chiru

Add Your Message Here
Post:
Bold text Italics Underline Create a hyperlink Insert a clipart image HASH(0x8358d54){Movie Clipart}
Show / hide regular icons selection options

Click on following links to open cliparts by Alphabetical Order

 A   B   C   D   E   F   G   H   I   J   K   L   M  

 N   O   P   Q   R   S   T   U   V   W   X   Y   Z  

Show / Hide Filmy icons selection options

Click on following links to open cliparts by Alphabetical Order

 A   B   C   D   E   F   G   H   I   J   K   L   M  

 N   O   P   Q   R   S   T   U   V   W   X   Y   Z  

Username: Posting Information:
This is a public posting area. Enter your username and password if you have an account. Otherwise, enter your full name as your username and leave the password blank. Your e-mail address is optional.
Password:
E-mail:
Options: Enable HTML code in message
Automatically activate URLs in message
Action: