Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 101
Default difficult function

A B C D E F G
1 aa 1x 2x 3x 4x 5x 6x
2 aa1 f o n
3 aa2 a r d o d b
4 aa3 i n ch be x

then using combination of xl embbedded function only, follow bellow.
f
o
n
a
r
d
o
d
b
i
n
ch
be
x

namely, change sequential column value to row value ???
not user defined function, but embedded excel function only...

*** Sent via Developersdex http://www.developersdex.com ***
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 38
Default difficult function

what's the question?
cut/copy
paste special
transpose

this will paste a row to a column or column to a row
Dave

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 101
Default difficult function



i want to make it with the function in embbeded in xl.

*** Sent via Developersdex http://www.developersdex.com ***
Reply
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
I need a difficult function ebank23 Excel Worksheet Functions 4 December 13th 08 04:28 PM
Difficult Average Function Connie Martin Excel Worksheet Functions 23 October 5th 08 09:46 PM
Difficult function Teacher in Revetal Excel Worksheet Functions 12 February 10th 07 10:56 AM
Difficult IF Function (For me at least) help pete321 Excel Worksheet Functions 1 June 15th 06 02:59 AM
Difficult function: help needed. Beertje Excel Discussion (Misc queries) 14 October 19th 05 11:24 AM


All times are GMT +1. The time now is 05:21 PM.

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

About Us

"It's about Microsoft Excel"