Assessing range values.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a selected range which consists of one column of various designated
two character codes .e.g. NW, UW,NR, NT and the like.

I need to be able to analyise the range and count the number of instances of
each code. The I then need to enter these values into another sheet in a row
under the various applicable column headings.

For eaxmple.

Source range looks like this:

UW
NW
NT
NW
NT
UT
NW

target looks like this
 
Hi Alan

i think the countif function will work for you

=COUNTIF(A1:A50,"UW")

with the original range in Sheet 1 and UW in sheet2 cell B1
=COUNTIF(Sheet1!$A$1:$A$50,B1)
- this can then be filled across the row

Cheers
JulieD
 
Julie,

Thanksfor your help it is more complicated.

The target range is not fixed as I want the code to add a new row of values
each time time the procedure is run so I need to use VBA to analyse the range
and enter the results into the target range automatically.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Assessing range values 2 1
VBA set thick borders around non empty cells in range 0
Application.Match and Ranges 2
Combo Box Wont Show Values 2
Copy sum of two columns from one workbook to one column in another 1
Clear a "moving" range offset from Target 31
Post my named ranges in column A 10
Simple "IF" Expression in Access Report 7

Back
Top