Info Type
View Option
Sort by Category
Show all from recent
29291. | Vivinavi Los Angeles 大家ともめて・・・(1kview/7res) |
Problem / Need advice | 2005/07/23 13:34 |
---|---|---|---|
29292. | Vivinavi Los Angeles Social Security Number, 無いと困りますか?(926view/5res) |
Free talk | 2005/07/23 10:08 |
29293. | Vivinavi Los Angeles 浄水器☆飲み水について(818view/2res) |
Free talk | 2005/07/22 14:55 |
29294. | Vivinavi Los Angeles アダルトスクール(フリースクール)(707view/1res) |
Problem / Need advice | 2005/07/22 13:35 |
29295. | Vivinavi Los Angeles トランスファーについて(563view/0res) |
Free talk | 2005/07/22 12:30 |
29296. | Vivinavi Los Angeles 痔になやんでます・・・(涙)。(1kview/13res) |
Problem / Need advice | 2005/07/22 10:04 |
29297. | Vivinavi Los Angeles 車の名義変更について。(637view/2res) |
Free talk | 2005/07/22 08:39 |
29298. | Vivinavi Los Angeles HIPHOPダンス(1kview/16res) |
Free talk | 2005/07/22 06:33 |
29299. | Vivinavi Los Angeles マフラー交換(700view/4res) |
Free talk | 2005/07/22 06:33 |
29300. | Vivinavi Los Angeles 株、デイトレやってる人or興味がある人(503view/5res) |
Free talk | 2005/07/22 06:33 |
Vivinavi Los AngelesMS EXCELについて質問です
- #1
-
- そうだなぁ。。。
- 2005/07/05 20:09
自分で色々試したんですが、何しろ詳しくないものでどうもうまくいきません。
例えば、2つのセルの間で、
Aのセルに "ABC" と入力した場合、Bのセルに "30"、または "XYZ" と入力したら "40"
(つまり、"ABC"=40, "XYZ"=30 を、一つのセルに文字を記入したら、別のセルにはその文字とリンクして数字が表される)
というふうに、自動的に記入されるようになんて出来るんでしょうか?
(わかりにくくてすみません)
もし分かる方がいらっしゃいましたらおしえてください。
- #4
-
- コヨーテ
- 2005/07/06 (Wed) 11:14
- Report
A | B
-----------------
1 ABC | 30
2 XYZ | 40
とどこかに表を作っておき、例えばB5のセル内に"=LOOKUP(A5,A1:B2)"と式を入れて、A5のセルにXYZと入力すると、B5の値が40と表示されますよ。
- #5
-
数字だけだったら30、40、と記入して、両方のcellをhighlightしてdragしたら(すみません、日本語でなんといったらいいのかわかりません)そのまま50、60、70とでますけど、ABCの場合はちょっとわかりませんでした。
- #6
-
- そうだなぁ。。。
- 2005/07/07 (Thu) 00:12
- Report
みなさま ありがとうございます。
コヨーテさんの方法でそれらしきものを得ました。
ただドラッグしてしまうとセルの数が一緒に変わってきてしまいますよね。
例えば、
"=LOOKUP(A5,A1:B2)"
をドラッグすると、次の段は。
"=LOOKUP(A6,A2:B3)"
そしてその下は、
"=LOOKUP(A7,A3:B4)" と。
一番左のセルは動いても良いのですが、「A1:B2」 の部分を固定しながらドラッグすることって出来るのでしょうか?
なんだか質問ばかりですみません。
- #7
-
- コヨーテ
- 2005/07/07 (Thu) 00:47
- Report
A1:B2を、$A$1:$B$1に変えてみてはどうですか?
- #8
-
- コヨーテ
- 2005/07/07 (Thu) 00:50
- Report
あ、$A$1:$B$2の間違いです。スイマセン。。
Posting period for “ MS EXCELについて質問です ” has been closed.
Please create new topic to continue the same topic.
- Find local business with Town Guide
-
- The only Japanese supermarket in Waikiki...
-
We offer a lineup that matches the season. Sashimi and sushi made from fresh fish are very popular with Hawaii residents and visitors alike. The spacious food court is also equipped with microwaves an...
+1 (808) 489-9020Mitsuwa Marketplace - Hawaii
-
- SAPIX USA is a private preparatory schoo...
-
Until now, we have only offered classes to Los Angeles residents via online class delivery from our New York school. With the opening of the San Jose school in February 2024, we are now able to offe...
+1 (650) 537-4089SAPIX USA
-
- We focus on "species conservation and en...
-
Currently, many animals, including polar bears and orangutans, are listed as endangered species due to reasons such as global warming and deforestation. Maruyama Zoo is committed to breeding these rar...
+81-11-621-1426札幌円山動物園
-
- Our educational goal is "to think, decid...
-
A charismatic math teacher with 18 years of experience as a principal at an educational institution for overseas children has opened a classroom where you can leave your child with peace of mind. Wit...
+1 (949) 932-0858ひのき補習校・学習塾Hinoki
-
- This glamping facility has a unique char...
-
Only 4 rooms in all: a 200 year old house, 2 trendy and stylish Scandinavian tents, and 1 "Sumibako" by the coveted outdoor brand snowpeak. Each is independent, with its own toilet & and shower, not d...
+81-90-7236-0208古民家とグランピング 和心村
-
- 送れる荷物の量なら日通のパックが絶対にお得です!
-
送れる荷物の量なら日通のパックが絶対にお得です!
+1 (562) 380-2202Nippon Express USA, Inc.
-
- "Savor the authentic flavors of Japanese...
-
Hana Ichimonme Kyoto Ramen is a restaurant located in the biggest Japanese building in the USA - Little Tokyo Galleria Shopping Center. Ichimonme is known for its famous authentic Japanese curry rice ...
+1 (213) 626-3514Hana Ichimonme
-
- < General Dentistry / Pediatric Dentistr...
-
Let us take care of your dental problems ! With over 25 years of experience in Fort Lee, we can help you keep your teeth healthy forever ✨ Our doctors examine you in Japanese, so even if you have diff...
+1 (201) 947-3777Lemoine Dental Group
-
- From English essays to elementary, middl...
-
• Flexible services, including home or office visits and skype lessons. • Skype lessons are available 24 hours a day, 7 days a week *Reservations required. • Experienced teachers • Reasonable rates...
+1 (909) 260-0353AAP - eTeachers
-
- We offer the best transportation and cha...
-
Thank you for reading our Town Guide. We are glad to hear that our service fee includes gratuities ! so you can use our service with peace of mind. Also, you may think that limousines are expensive...
+1 (310) 508-9272Akihira Enterprise Limousine Service
-
- The latest inventory information has bee...
-
We have been supporting our customers' car life in the U.S.A. for 28 years ! With the theme of "Proof of Trust !", we value the bond with our customers ! ! AB Auto Town's business policy is "communit...
+1 (310) 212-7990AB Auto Town
-
- Since the company was established in Feb...
-
We have been in the Hawaii real estate brokerage business since 1986, and our staff is committed to providing you with top-notch customer service based on our many years of experience and achievements...
+1 (808) 944-3003Shuko Realty
-
- From kindergarten children to elementary...
-
Hawaii Private Tutoring x Tutoring School = Home tutoring to dramatically improve academic performance ! ! From kindergarten children to elementary school students, high school students, university s...
+1 (808) 306-1677Focus Labo LLC | フォーカス教育研究所
-
- Professional teachers with 30 years of e...
-
I want to help you, somewhere on this earth." More than 30 years have passed since I started my career as a private school teacher. Thanks to the wonderful students I have taught, I have been able to...
+81-584-32-4990オンラインプロ家庭教師「匠takumi」
-
- A safe and reliable dental office where ...
-
In addition to general dentistry, Morita Dental offers pediatric dentistry, cosmetic dentistry, and implant treatment. Our office is located across the street from Marukai Dental Clinic to make it eas...
+1 (408) 775-7770Morita Dental