 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / December 2007Isolate on date by Align Left??
I have a standard report that I receive every day from IT and it can't be altered by IT. So once I have it opened in Excel I can manipulate it but on column has data in Column B where some of it is Aligned Left and some is Aligned Right. What I want to do is write a statement in Column A that only returns data from Column B that is Aligned left. Does anyone have an idea how to do this?  SignatureGS By default TEXT is aligned left and NUMBERS are aligned right. |text | = TEXT | 12 | = NUMBER | 12/26/2007| = NUMBER (dates are NUMBERS) Your subject line says: Isolate on date by align left What does that mean? What does "date" have to do with it? What type of data is in column B? SignatureBiff Microsoft Excel MVP >I have a standard report that I receive every day from IT and it can't be > altered by IT. So once I have it opened in Excel I can manipulate it but [quoted text clipped - 5 lines] > how > to do this? Although i have the same problem as biff you could try this in column A Cell A1: =if(istext(B1),B1,"") maybe that's what you're looking for, otherwise you could make a UDF. Try to explain better what the problem is, or what your goal is. hth Carlo > By default TEXT is aligned left and NUMBERS are aligned right. > [quoted text clipped - 24 lines] > > - Show quoted text - The statement =if(isnumber or =if(istext .... work... Now here is my new problem... A 1 Apple 2 3 4 Pear 5 6 7 8 9 Peach 10 Is there a way to write a statement so that cells A2 & A3 will say Apple, Cell A5:A8 to state Pear, and Cell A10 to state Peach? The problem I have is each change in data is a different item and I don't want to cut and paste 6,000 + rows... SignatureGS > Although i have the same problem as biff you could try this in column > A [quoted text clipped - 36 lines] > > > > - Show quoted text - You could do following: in A1: =if(istext(B1),B1,"") in A2 and following: =if(istext(B2),B2,A1) hth Carlo On Dec 27, 1:37 pm, Gary F Shelton <GaryFShel...@discussions.microsoft.com> wrote: > The statement =if(isnumber or =if(istext .... work... Now here is my new > problem... [quoted text clipped - 61 lines] > > - Show quoted text - Assuming that your first entry is *always* a text entry: text 1 2 3 text 1 text text 1 2 3 Try this formula in column A and copy down as needed: =LOOKUP("zzzzz",B$1:B1) SignatureBiff Microsoft Excel MVP You could do following: in A1: =if(istext(B1),B1,"") in A2 and following: =if(istext(B2),B2,A1) hth Carlo On Dec 27, 1:37 pm, Gary F Shelton <GaryFShel...@discussions.microsoft.com> wrote: > The statement =if(isnumber or =if(istext .... work... Now here is my new > problem... [quoted text clipped - 73 lines] > > - Show quoted text - > .. Now here is my new problem... Think you could try Debra Dalgleish's page for ways to fill in the col blanks: http://www.contextures.com/xlDataEntry02.html Excel -- Data Entry -- Fill Blank Cells Fill Blank Cells Fill Blank Cells Programmatically (Sub FillColBlanks() by Dave Peterson) SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- Hi Max or anyone, I still need some help. I have pasted the code from Dave Peterson into my active excel fiel and don't know what to do. I have saved the file etc... I so want to learn how to do this as it will help me daily. So let me go back to what I have and then maybe someone can help me solve it. With the Dave Peterson UDF in VBA it should take the data from Column B and make it look like the data in Column E from a systematic approach. A B C D E 1 100102 100102 2 100102 3 100102 4 100102 5 100102 6 100160 100160 7 100160 8 100160 9 100160 10 160100 160100 11 160100 12 13 14 160520 15 Any help in getting me to the next step is greatly appreciated. SignatureGS > > .. Now here is my new problem... > [quoted text clipped - 6 lines] > Fill Blank Cells Programmatically > (Sub FillColBlanks() by Dave Peterson) Dave's a subroutine, not a UDF. You could install the sub in a regular module & run it like this: In Excel, in any sheet, Press Alt+F11 to go to VBE Click Insert > Module Toggle over to the webpage & copy Dave's Sub FillColBlanks() [copy all lines until & inclusive of the last line: End Sub] then paste it into the code window (the whitespace on the right) Press Alt+Q to get back to Excel In Excel, Select the col that you want to fill down from above Press Alt+F8 to bring up the Macro dialog Double-click on "FillColBlanks" to run it (or select "FillColBlanks", click Run) SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- > Hi Max or anyone, > [quoted text clipped - 36 lines] > > Any help in getting me to the next step is greatly appreciated.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.