Log In
Create Account
SlickerTalk
Search Archives
The Leaderboard
The FAQ
Login
Create Account
Search
Dr. S. Talk
TT/ST Wiki
How Well Do You Know ...
RSS Feed
Hosting by DigitalOcean
Support ST on Ko-Fi
Links Only
50 Results
100 Results
250 Results
500 Results
1000 Results
5000 Results
2 Weeks
2 Months
6 Months
1 Year
2 Years
5 Years
All Time
Live
Down to Post
Backboards:
Live
________________
1: Nov 30, 15:54
2: Nov 30, 09:41
3: Nov 29, 16:44
4: Nov 29, 08:01
5: Nov 28, 16:19
6: Nov 28, 09:42
7: Nov 27, 18:07
8: Nov 27, 12:04
9: Nov 27, 08:26
10: Nov 26, 18:06
11: Nov 26, 12:05
12: Nov 26, 08:29
13: Nov 25, 18:33
14: Nov 25, 11:12
15: Nov 25, 07:08
16: Nov 24, 13:17
17: Nov 23, 18:13
18: Nov 23, 06:17
19: Nov 22, 13:24
20: Nov 22, 09:09
Posts: 152
In response to
"
can you use sumif to compile the data? -- nm
"
by
amanda jeans
I don't think so? I'm not looking to sum numbers, this is to combine a list of text data
Posted by
Max
Oct 13 '21, 13:40
=Sheet1!A2:A4&Sheet2!D6:D8 outputs:
A2D6
A3D7
A4D8
I need
A2
A3
A4
D6
D7
D8
and continue to spill when new rows are added to Sheet1 and/or Sheet2
Responses:
I have an idea that might work using OFFSET, maybe? -- (edited)
-
znufrii
Oct 13, 14:05
Post a message
top
Replies are disabled on threads older than 7 days.