Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default 提取另一工作表整行内容

Sheet1-单元*内容在表*排列:
列 B C D E F G
行 甲类 910 920 930 940 950
2 乙类 610 620 630 640 670
3
Sheet2-单元*内容在表*排列:
列 B C D E F G H I
行 定类甲类 甲类 乙类 乙类 甲类
2 人名 *三 李四 李一 *五 李七
3 1月 920 620 650 910 630 甲类 910 920 930
4 2月 620 610 610 930 920 空(不成立)
5 3月 950 620 940 610 940 甲类 910 920 930
6 4月 610 610 610 610 620 空(不成立)
7
求B3:F3最大值*于B1:F1类别时就把该类 在Sheet1甲类,910,920
或乙类,610,620,复印在Sheet2-G3,H3,I3否则为空
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 171
Default 提取另一工作表整行内容

English:

You might be able to get more help in the Japanese newsgroup -
microsoft.public.jp.excel.

Otherwise, please try to translate your problem into English
(http://babelfish.altavista.com/).

Translated Japanese from Babel Fish:

日本のニユースグループ("microsoft.publi c.jp.excel" 得られる) のより多くの助けをかもしれない
または英語にあなたの問題を翻訳す ことを試みることができる。

Hopefully Babel Fish translated this well enough for a descent
understanding. Sometimes their translations from and to Japanese are pretty
bad.

Mark Ivey

"*春喜" wrote in message
...
Sheet1-单元*内容在表*排列:
列 B C D E F G
行 甲类 910 920 930 940 950
2 乙类 610 620 630 640 670
3
Sheet2-单元*内容在表*排列:
列 B C D E F G H I
行 定类甲类 甲类 乙类 乙类 甲类
2 人名 *三 李四 李一 *五 李七
3 1月 920 620 650 910 630 甲类 910 920 930
4 2月 620 610 610 930 920 空(不成立)
5 3月 950 620 940 610 940 甲类 910 920 930
6 4月 610 610 610 610 620 空(不成立)
7
求B3:F3最大值*于B1:F1类别时就把该类 在Sheet1甲类,910,920
或乙类,610,620,复印在Sheet2-G3,H3,I3否则为空


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default 提取另一工作表整行内容

首先感谢:
Mark Ivey(*文:马克艾维)
虽然您没对本人问题作出回*,也感 您浏览我问题。
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 171
Default 提取所゚一工作表整行内容

Many apologies. I have difficulty deciphering between the two sometimes.


Mark Ivey

"kiwis" wrote in message
...
The language used is chinese not japanese.


On Mar 3, 10:22 am, "Mark Ivey" wrote:
English:

You might be able to get more help in the Japanese newsgroup -
microsoft.public.jp.excel.

Otherwise, please try to translate your problem into English
(http://babelfish.altavista.com/).

Translated Japanese from Babel Fish:

日本のニユースグループ("microsoft.publi c.jp.excel" 得られる) のより多くの助けをかもしれない
または英語にあなたの問題を翻訳す ことを試みることができる。

Hopefully Babel Fish translated this well enough for a descent
understanding. Sometimes their translations from and to Japanese are
pretty
bad.

Mark Ivey

"*春喜" wrote in message

...



Sheet1-单元*内容在表*排列:
列 B C D E F G...
行 甲类 910 920 930 940 950
2 乙类 610 620 630 640 670
3
Sheet2-单元*内容在表*排列:
列 B C D E F G H I...
行 定类甲类 甲类 乙类 乙类 甲类
2 人名 *三 李四 李一 *五 李七
3 1月 920 620 650 910 630 甲类 910 920 930...
4 2月 620 610 610 930 920 空(不成立)
5 3月 950 620 940 610 940 甲类 910 920 930...
6 4月 610 610 610 610 620 空(不成立)
7
求B3:F3最大值*于B1:F1类别时就把该类 在Sheet1甲类,910,920...
或乙类,610,620...,复印在Sheet2-G3,H3,I3...否则为空- Hide quoted text -


- Show quoted text -



  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 735
Default 提取所゚一工作表整行内容

This is the second post on the same topic. It is very unlikely you will get
in here.

--

Regards,
Nigel




"Mark Ivey" wrote in message
...
Many apologies. I have difficulty deciphering between the two sometimes.


Mark Ivey

"kiwis" wrote in message
...
The language used is chinese not japanese.


On Mar 3, 10:22 am, "Mark Ivey" wrote:
English:

You might be able to get more help in the Japanese newsgroup -
microsoft.public.jp.excel.

Otherwise, please try to translate your problem into English
(
http://babelfish.altavista.com/).

Translated Japanese from Babel Fish:

日本のニユースグループ("microsoft.publi c.jp.excel" 得られる) のより多くの助けをかもしれない
または英語にあなたの問題を翻訳す ことを試みることができる。

Hopefully Babel Fish translated this well enough for a descent
understanding. Sometimes their translations from and to Japanese are
pretty
bad.

Mark Ivey

"*春喜" wrote in message

...



Sheet1-单元*内容在表*排列:
列 B C D E F G...
行 甲类 910 920 930 940 950
2 乙类 610 620 630 640 670
3
Sheet2-单元*内容在表*排列:
列 B C D E F G H I...
行 定类甲类 甲类 乙类 乙类 甲类
2 人名 *三 李四 李一 *五 李七
3 1月 920 620 650 910 630 甲类 910 920 930...
4 2月 620 610 610 930 920 空(不成立)
5 3月 950 620 940 610 940 甲类 910 920 930...
6 4月 610 610 610 610 620 空(不成立)
7
求B3:F3最大值*于B1:F1类别时就把该类 在Sheet1甲类,910,920...
或乙类,610,620...,复印在Sheet2-G3,H3,I3...否则为空- Hide quoted text -

- Show quoted text -




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



All times are GMT +1. The time now is 05:29 AM.

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"