![]() |
#1
|
|||
|
|||
![]() i want to fill data in credit account of my customer automatically when his name is entered for example my customer name is "A" so i use this formula i make a helper sell in which i put cutomer name "A" in L1 so here is my formula =IF(B3:B13=$L$1,A3:A13,"") i have got this simple formula but it leaves spaces when customer name does not comes (L1 is customer name's cell) i want to get rid of those empty cells which comes because of "" . so how do i do this? |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
ClearSkies | Excel | 1 | 03-04-2011 01:06 PM |
Simple or what? | nebb | Publisher | 0 | 09-23-2010 07:00 AM |
Simple template | kieransymes | Word | 0 | 03-08-2010 02:13 AM |
Simple formulas | den hobbelder | Word | 1 | 02-26-2010 01:53 PM |
Excel formula needed. | Rod | Excel | 1 | 08-03-2009 06:55 AM |