Related:
- Excel 2007 if and function
- Save as pdf office 2007 - Download - Other
- Excel date format dd.mm.yyyy - Guide
- Excel free download - Download - Spreadsheets
- Agp function - Guide
- Number to words in excel - Guide
2 responses
Saman.tha
Posts
1382
Registration date
Monday May 25, 2009
Status
Moderator
Last seen
September 14, 2015
33
Sep 29, 2010 at 08:48 AM
Sep 29, 2010 at 08:48 AM
I hope I didn't get it wrong. Juste type into C1: =A1+B1 and tap enter. Afterwards you can copy it (just drag) to all the other cells in the C column. The formula will automatically adapt to the number of the row like =A2+B2 or =A3+B3 ....
Is not like that
sheet 1
A- B- C-
621- 308043- EIG
621- 308044- OPBEH
621- 308045- GEBR
622- 308046- EIG
622- 308047- OPBEH
622- 308048- GEBR
623-308049- EIG
623-308050- GEBR
623-308051- OPBEH
Sheet 2
A B
621 ?
622 ?
623 ?
on the second sheet I have the number 621
need de number from B combine if A combine with C on sheet 1
and have number 621 on collum A on the second sheet.
so how can i have Number on kolom B on the second sheet IF i only want it from EIG?
if i have more than 1000 numbers under each other.
sheet 1
A- B- C-
621- 308043- EIG
621- 308044- OPBEH
621- 308045- GEBR
622- 308046- EIG
622- 308047- OPBEH
622- 308048- GEBR
623-308049- EIG
623-308050- GEBR
623-308051- OPBEH
Sheet 2
A B
621 ?
622 ?
623 ?
on the second sheet I have the number 621
need de number from B combine if A combine with C on sheet 1
and have number 621 on collum A on the second sheet.
so how can i have Number on kolom B on the second sheet IF i only want it from EIG?
if i have more than 1000 numbers under each other.
Sep 29, 2010 at 09:13 AM
sheet 1
A- B- C-
621- 308043- EIG
621- 308044- OPBEH
621- 308045- GEBR
622- 308046-
622- 308047-
622- 308048-
623-308049-
623-308050-
623-308051-
Sheet 2
A B
621 ?
622 ?
623 ?
on the second sheet I have the number 621
need de number from B combine if A combine with C on sheet 1
and have number 621 on collum A on the second sheet.
so how can i have Number on kolom B on the second sheet IF i only want it from EIG?
if i have more than 1000 numbers under each other.
Sep 29, 2010 at 09:26 AM