| Author | Message | ||
Kindal Side Hero Username: Kindal Post Number: 4105 Registered: 09-2007 Posted From: 14.139.128.20 Rating: N/A |
DB lo thread vesi, excel lo formula teluskune lopu dummy table create chesi, aa task finish chesi undachu ani Sesani whatsapp lo cheppadu  5 mins after your birth, they decide your name, nationality, religion & sect & you spend rest of ur life defending something u didn't choose. | ||
Ferrari Hero Username: Ferrari Post Number: 10471 Registered: 10-2008 Posted From: 173.36.240.166 Rating: N/A |
yes..kaani ippudu nenu test db ki velli oka table create chesi values anni insert chesi outpuet vache lopu excel lo quick ga cheyacha ledha ani doubt.. | ||
Moviebuff001 Comedian Username: Moviebuff001 Post Number: 1596 Registered: 06-2013 Posted From: 208.92.228.62 Rating: N/A |
This will work for you . TAB B is data selection and 1 is column number if you do not know. | ||
Moviebuff001 Comedian Username: Moviebuff001 Post Number: 1595 Registered: 06-2013 Posted From: 208.92.228.62 Rating: N/A |
VLOOKUP(B1,$A$1:$A$10,1,) | ||
Sony Legend Username: Sony Post Number: 30305 Registered: 12-2006 Posted From: 170.48.2.186 Rating: N/A |
macros codes ivakandi, simple vlookup is enough | ||
Sony Legend Username: Sony Post Number: 30304 Registered: 12-2006 Posted From: 170.48.2.186 Rating: N/A |
Solution Select Column B entries from 1 to 100 rows and LIST them as TAB B - follow this http://www.jkp-ads.com/Articles/ExcelNames01.asp in Column C use this formula = IFERROR(VLOOKUP(A1, TAB B, 1, FALSE), " ") | ||
Rajin Hero Username: Rajin Post Number: 15737 Registered: 05-2012 Posted From: 73.211.136.147 Rating: N/A |
ferrari annai,naaku ardham ayyinthaa varaku, you need macro or column/cell to unique name define chesukuni table , structured way formula raasukovali search filtering structured data in excel types ,... | ||
Abcdefghij Hero Username: Abcdefghij Post Number: 18915 Registered: 02-2007 Posted From: 68.42.113.64 Rating: N/A |
https://support.microsoft.com/en-us/kb/213367 Post by Knf: bittter annai, welcome RS prakasam varaku madi, Prakasm nunchi UA vaaraku meeedi http://www.chalanachithram.com/cgi-bin/discus/show.cgi?tpc=115&post=5144373#POST5144373 | ||
Abcdefghij Hero Username: Abcdefghij Post Number: 18914 Registered: 02-2007 Posted From: 68.42.113.64 Rating: N/A |
sql lone two column data cut and paste chessi select * from table where column1 in (select column2 from table) ante vostadi ga Post by Knf: bittter annai, welcome RS prakasam varaku madi, Prakasm nunchi UA vaaraku meeedi http://www.chalanachithram.com/cgi-bin/discus/show.cgi?tpc=115&post=5144373#POST5144373 | ||
Ferrari Hero Username: Ferrari Post Number: 10470 Registered: 10-2008 Posted From: 173.36.240.166 Rating: N/A |
Macros raasthava..inthaki na requirement evariki ardham kaledhu anukunta..simple ga cheptha.. Col A: sesani_innocent_fellow_ccdb nanigadu_utthamudaina_gopi warrior_blonde_folks bumper_mega_crying Col B: sesani_innocent_fellow_ccdb warrior_blonde_folks maharshi_firstday_review paina vi anni SQL tables..ippudu Col B lo unna okkoka value ni Col A tho compare chesi okavela Col A lo aa value unte Col C ki copy avvali..so adhi requirement.. | ||
Sesani Legend Username: Sesani Post Number: 44606 Registered: 08-2014 Posted From: 172.58.201.255 Rating: N/A |
tammudu joke mic.. Unix enduku le bokka kaani Sesani.ccdb ki mail kottu nee excel (If it's not confidential).. nen chesi pamputa | ||
Rowdy Legend Username: Rowdy Post Number: 37866 Registered: 01-2010 Posted From: 50.225.47.29 Rating: N/A |
I second this, already evaranna second chesthe nenu third chestanu | ||
Ferrari Hero Username: Ferrari Post Number: 10469 Registered: 10-2008 Posted From: 173.36.240.166 Rating: N/A |
there is a problem with this formula ani edho error vastundhi..anyways thanks for your help..unix lo copy chesi compare chesukunttuna.. | ||
Goldrush Side Hero Username: Goldrush Post Number: 5020 Registered: 03-2012 Posted From: 192.234.135.34 Rating: N/A |
=VLOOKUP(B2|A:A|1|0) C2 loo paina icchindhi icchi enter kottandi. And then double click field, you should see results in coulumn C. #N/A vasthe record table A loo lennatuu, lekapothey vunnatuu(Matching found) | ||
Ferrari Hero Username: Ferrari Post Number: 10468 Registered: 10-2008 Posted From: 173.36.240.166 Rating: N/A |
Records kaadhu..SQL tables.. | ||
Ferrari Hero Username: Ferrari Post Number: 10467 Registered: 10-2008 Posted From: 173.36.240.166 Rating: N/A |
 | ||
Ferrari Hero Username: Ferrari Post Number: 10466 Registered: 10-2008 Posted From: 173.36.240.166 Rating: N/A |
ledhu bhayya..col B lo konni tables Col A lo unnayi..so aa tales enti anevi col C lo ravali.. Kukat Bhayya aa IF query already use chesi result rakappothene e thed esthini | ||
Kuyyo_morro Megastar Username: Kuyyo_morro Post Number: 23056 Registered: 02-2011 Posted From: 173.169.22.176 Rating: N/A |
=IF(A2=B2,"Match","") | ||
Sesani Legend Username: Sesani Post Number: 44603 Registered: 08-2014 Posted From: 207.140.166.10 Rating: N/A |
plz deport Ferrari tammudu | ||
Sony Legend Username: Sony Post Number: 30302 Registered: 12-2006 Posted From: 170.48.2.186 Rating: N/A |
simple Col A lo 500 records anuko, Col B lo 100 records Col C lo aa remaining 400 ravali | ||
Kranth1 Comedian Username: Kranth1 Post Number: 1467 Registered: 03-2016 Posted From: 209.136.235.11 Rating: N/A |
Babu meaning records emo VLOOKUP tho cheyyochu as Sony said Eppudu raajakeeya nayakulni vimarsinche pourudu raajakeeya nayakudu ayithe inka ekkuva dochukuntadu - RGV | ||
Kukatpally Megastar Username: Kukatpally Post Number: 23896 Registered: 07-2014 Posted From: 57.69.14.65 Rating: N/A |
=IF(ISERROR(MATCH(B1,$A$1:$A$500,0)),"",B1) use this to generate column C | ||
Gatti_gunde Megastar Username: Gatti_gunde Post Number: 21028 Registered: 02-2010 Posted From: 204.194.77.3 Rating: N/A |
kochen ee ardham avvaledhu Col A lo 500 tables enti Boob annai ni kindhesi thanthe DB set aithadhi | ||
Sony Legend Username: Sony Post Number: 30301 Registered: 12-2006 Posted From: 170.48.2.186 Rating: N/A |
VLOOKUP function maloom????, easiest. ledu ante sort both Columns and do IF query and manually remove the duplicate entries | ||
Mandharam Side Hero Username: Mandharam Post Number: 2650 Registered: 02-2008 Posted From: 122.171.118.234 Rating: N/A |
sambar batch gurthu vachindhi kabali collections batch | ||
Ferrari Hero Username: Ferrari Post Number: 10465 Registered: 10-2008 Posted From: 173.36.240.166 Rating: N/A |
column A lo oka 500 tables unnayi..column B lo oka 100 tables unnayi...column B ni column A tho compare chesi duplicate result in Column C lo pettali.. |