Member Avatar for rickyfish

Sorry if this is in the wrong place

I have an interesting problem trying to sort data in excel.

I have a spreadsheet which has 20000 odd cells in 20 or so columns and i only need info from 4

cal a =job
col b =job name
col s = trade
col v = value

my problem is each of the columns has multiple instances of the same detail so I need to create another workbook with
col a job no
col b job name
col c trade 1
col d trade 2
col e trade 3

the info for col a and b I have sorted so that they only have 1 instance of each per row
I now need to populate c1 to e500 with the value per trade per job.

I thought about vlookup or sumif but cant quite get it right

any help would be greatly appreciated


Ricky

  • 2 Contributors
  • 1 Reply
  • 72 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by hopalongcassidy
Member Avatar for hopalongcassidy

What you are asking for is a program that will create a new worksheet from your old one. This involves a little bit of programming.

I can do this for you, but I will charge a fee ($100).

RSVP to this thread.

Hoppy

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.