Trying to modify a list

  • Thread starter Thread starter trofie99
  • Start date Start date
T

trofie99

hello. i ran a query at my job that provides me with 975 rows of data. many
of the rows are duplicated because of the "project number" that is a part of
my query. I would like to duplicate all rows of data that have the project
number listed more than once.

i am trying to capture unit totals for each project number and only need the
project number mentioned once. the project numbers are in column a. i hope
this makes sense as i know this is doable but can not seem to figure it out.
 

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

Excel VBA - counting cells by colors and names to it in two different rows. 0
How to create a bubble chart with more than 2 variables 0
Pivot tables - counting unique numbers 2
Inserting rows using a list of numbers 3
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Excel lookup across entire workbook 1
Vlookup to create a list from a larger list 3
generate a list from a single row of data 4

Back
Top