ExcelBanter - display results 2 of 2

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - display results 2 of 2 (https://www.excelbanter.com/excel-discussion-misc-queries/228497-display-results-2-2-a.html)

Shanen

display results 2 of 2

I have 2 columns of data. Simple numbers.
Column A Column B Column C
5 5 5 of 5
4 2 2 of 4
6 1 1 of 6

I want Column C to show the results of a and b in terms of x number of items
out of x .

Thanks

--
Shanen

Gary''s Student

display results 2 of 2

In C1 enter:

=B1 & " of " & A1
--
Gary''s Student - gsnu200848

"Shanen" wrote:

I have 2 columns of data. Simple numbers.
Column A Column B Column C
5 5 5 of 5
4 2 2 of 4
6 1 1 of 6

I want Column C to show the results of a and b in terms of x number of items
out of x .

Thanks

--
Shanen

All times are GMT +1. The time now is 10:22 PM.