LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 14
Default missing data in columns[empty cells]

i m unable to progrm this problem as i m novice
i have data in some columns ,

one column have values in all rows [ say in row 1 to row 15] while
its adjacent column2 have some missing data [say in row 6 no data ]

so i want to chk from column 1 if in the 6th row data is present n in
colmn2 6th row data missing then
copy the data from row7 to row6 in column2

likewise in case of all columns where ever data is missing above
procedure left adjacet column shud b checked

hope some of u find time to help me out
waitng for ur replys

many thanx in advance

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
charting missing data (empty cells bug) Kazim Mammadhuseyn Charts and Charting in Excel 2 October 27th 09 08:51 AM
how to return non empty cells over several columns iago Excel Discussion (Misc queries) 4 June 11th 07 03:31 PM
Delete row if 3 columns have empty cells in a row Les Stout[_2_] Excel Programming 7 April 18th 07 06:30 PM
Charting with missing data or empty strings from vlookup() MJS Charts and Charting in Excel 2 February 23rd 07 07:16 AM
Filling in empty cells in columns koba Excel Discussion (Misc queries) 2 November 8th 05 10:03 PM


All times are GMT +1. The time now is 07:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"