Microsoft Office

Microsoft Office Questions? Ask a IT Expert for Support ASAP

Ask a Computer Expert,
Get an Answer ASAP!

Microsoft Office

I am using Excel 2007. I have a large worksheet with Approx

Customer Question
I am using Excel 2007...
I am using Excel 2007. I have a large worksheet with Approx 112K rows. I am interested in specific groups of transactions where a unique account number is XXXXX and I need all of the associated account transactions. There could be anywhere from 2 - 10 transactions within a group. There is a unique sequence number used for each group of transactions. I can't figure out how to extract only the groups that have the unique account number, with all of the associated accounts. Obviously I can do a filter on the unique acct number but that does not give me the other account transactions associated with it. I have read Bill Jelen's Mr Excel book trying to find a solution but can't identify one. This book has been very helpful for other solutions but need help with this one.
Submitted: 4 years ago.Category: Microsoft Office
Show More
Show Less
Ask Your Own Microsoft Office Question
Answered in 38 minutes by:
4/2/2013
Microsoft Office Technician: The-PC-Guy, Computer Manager replied 4 years ago
The-PC-Guy
The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 2,038
Experience: 20 years experience providing remote computer support
Verified

The-PC-Guy :

Thanks for using JustAnswer. My name is Andrew, I will do whatever I can to answer your question

The-PC-Guy :

if I am to understand you correctly

The-PC-Guy :

you have a collumn of account numbers

The-PC-Guy :

123

The-PC-Guy :

45

The-PC-Guy :

6

The-PC-Guy :

122

The-PC-Guy :

124

The-PC-Guy :

125

The-PC-Guy :

123

The-PC-Guy :

ect

The-PC-Guy :

then a column of other data

The-PC-Guy :

and you want to see the other data where ever the number 123 appears in this colllum?

The-PC-Guy :

does this about sum it up?

JACUSTOMER-dffq6gio- :

Not quite. Each of the above account numbers you outlined can appear numerous times, each with a different transaction number. If the account 123 appears in a transaction along with any other account number, I want to see that with all associated account numbers.

JACUSTOMER-dffq6gio- :
Cust Number Customer Name Date Sequence Num Account
451550 MURHPY'S 2/23/2007 95361642 008008
451550 MURHPY'S 2/23/2007 95361642 001017
451648 MURPHY'S AT THE PINES 2/23/2007 95361644 008008
451648 MURPHY'S AT THE PINES 2/23/2007 95361644 001017
451657 MURPHY'S 2/23/2007 95361645 008008
451657 MURPHY'S 2/23/2007 95361645 001017
451660 MURPHY'S 2/23/2007 95361646 008008
451660 MURPHY'S 2/23/2007 95361646 001017
452697 MURPHY'S ATCO 2/23/2007 95361647 008008
452697 MURPHY'S ATCO 2/23/2007 95361647 001017
459024 MURPHY'S AT THE LAKE 2/23/2007 95361660 008008
459024 MURPHY'S AT THE LAKE 2/23/2007 95361660 001017
459047 MURPHY AT THE FORGE 2/23/2007 95361666 008008
JACUSTOMER-dffq6gio- :
150100 CASH SALE 3/2/2007 95743963 008008
150100 CASH SALE 3/2/2007 95743963 812840
150100 CASH SALE 3/2/2007 95743963 812840
150100 CASH SALE 3/2/2007 95743963 812840
JACUSTOMER-dffq6gio- :

If you look at the following examples, at the bottom of this example there is a transaction number 95743963 with 2 different account numbers and 4 transactions. Any time the account 812840 shows, i want to be able to select those 4 transactions. Since none of the account numbers above include this account, I am not interested and don't want to include in my data.

JACUSTOMER-dffq6gio- :

I forgot to include the dollar amounts. There would be an amount associated with each of the accounts.

The-PC-Guy :

this is sounding way to complicated, i will opt out so another expert can help you

JACUSTOMER-dffq6gio- :

Would some type of nested If statement work?

Ask Your Own Microsoft Office Question
Microsoft Office Technician: The-PC-Guy, Computer Manager replied 4 years ago
it would be possible to do something like this where if you have column A on a separate sheet filled with the customer numbers you want to match up

I can have the sheet fill in the corresponding account numbers. The only issue is you will get duplicates if they exist, there is no way around this.

Also I would prefer to work from your actual sheet if possible.
Ask Your Own Microsoft Office Question
Customer reply replied 4 years ago

I did not get a satisfactory answer nor does it appear that you are aware of what I am asking, and I see that my account has been fully charged. Please advise what further information you need so that I can help you to get an appropriate resolution.

Customer reply replied 4 years ago

You apparently did not read the information I provided earlier. I am not trying to match data to a specific customer. If that were the case I could easily do that with a V Lookup. Again, what I am trying to do is retrieve data with a specific account number, 812840 as shown above, and also pull any additional data associated with that transaction's sequence number. I will be unavailable for a couple of days, so if you need a file I can possibly send to you on Friday. Please provide an email address to which I can send the file.


 

Microsoft Office Technician: The-PC-Guy, Computer Manager replied 4 years ago
I am not sure I fully understand the requirements. It would be best for me to refer you to another expert that can better assist you.
Ask Your Own Microsoft Office Question
Microsoft Office Technician: Rachel-Mod, Moderator replied 4 years ago
Rachel-Mod
Rachel-Mod, Moderator
Category: Microsoft Office
Satisfied Customers: 5
Experience: Moderator
Verified

Hello,

I’m a moderator for this topic. It seems the Professional has left this conversation. This happens occasionally, and it's usually because the Professional thinks that someone else might be a better match for your question. I've been working hard to find a new Professional to assist you with your question, but sometimes finding the right Professional can take a little longer than expected.

I wonder whether you're ok with continuing to wait for an answer. If you are, please let me know and I will continue my search. If not, feel free to let me know and I will cancel this question for you.

Thank you!

Rachel

Ask Your Own Microsoft Office Question
Ask The-PC-Guy Your Own Question
The-PC-Guy
The-PC-Guy
The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 2,038
2,038 Satisfied Customers
Experience: 20 years experience providing remote computer support

The-PC-Guy is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

< Previous | Next >

Meet the Experts:

jstinehelfer

jstinehelfer

Information Systems Manager

36 satisfied customers

A+ Comptia Certified computer repair

JasonJames122

JasonJames122

Computer Enthusiast

0 satisfied customers

I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business

Jess M.

Jess M.

Computer Support Specialist

684 satisfied customers

Computer Software Specialist for more than 10 years

The-PC-Guy

The-PC-Guy

Computer Manager

2,038 satisfied customers

20 years experience providing remote computer support

James K.

James K.

Consultant

260 satisfied customers

Technical Director of IT Company

IT Miro

IT Miro

Computer Scientist

156 satisfied customers

Bachelor's Degree in Information Technology, Microsoft Certified Professional

Chris L.

Chris L.

Support Specialist

143 satisfied customers

Certified Expert with over 10 years experience.

< Previous | Next >

Related Microsoft Office Questions
I have changed server and I am unable to access my account.
I have changed server and I am unable to access my account. Need to reset my password. … read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
684 satisfied customers
I purchased a computer several years ago from Staples which
I purchased a computer several years ago from Staples which installed Microsoft office. However, they did not give me the disk it was automatically installed in the computer. The computer crashed and … read more
Cody
Cody
Computer Science
1,468 satisfied customers
ON WORKSHEETS tHE HEADINGS OF FUNCTIONS ACROSS THE TOP OF
oN WORKSHEETS tHE HEADINGS OF FUNCTIONS ACROSS THE TOP OF WORKSHEET ARE NO LONGER VISIBLE. pLEASE ADVISE … read more
Russell H.
Russell H.
computer technology consultant
Vocational, Technical or Trade Scho
775 satisfied customers
I purchased Office 365 yesterday and need to migrate from
I purchased Office 365 yesterday and need to migrate from mail into outlook all my emails can you assist with this … read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
I need to reload my Office Home and Business 2016 where do I
I need to reload my Office Home and Business 2016 where do I need to go to download and enter my product key? … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,214 satisfied customers
Just put in new Hard- drive. I have an icon on the screen
just put in new Hard- drive. I have an icon on the screen for OUTLOOK but no connection to the internet. If I wish I can get my e-mail through google but it is a long arduous task. How do I fix it, th… read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
684 satisfied customers
Is there any chance Microsoft will stop converting files to
Is there any chance Microsoft will stop converting files to "Read Only" in Excel. This is a very frustrating part of Excel. … read more
UranIT
UranIT
IT Consultant, Network and System Admin
Associate Degree
470 satisfied customers
Just received a new asus computer It wants us to log buy
Just received a new asus computer It wants us to log buy keeps asking for a code which I don't have? … read more
Cody
Cody
Computer Science
1,468 satisfied customers
I am new to Word 15.40. How do I find Avery Labels? The old
I am new to Word 15.40. How do I find Avery Labels? The old version was Directly to "Labels" … read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
I am using MS Word 2010. I need help setting up a template
I am using MS Word 2010. I need help setting up a template for a legal pleading with 26 numbered lines per page and a vertical double line between the numbers and the main body of the text. … read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
684 satisfied customers
Received error code 25521 when installing. Alot. Few months
few months ago. removed all previous versions of office … read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
684 satisfied customers
Have a Word document that I need to make into a template but
Have a Word document that I need to make into a template but want the header editable too - currently this is losing its formatting when placing into a header, whilst keeping it's edit-ability. Additi… read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
I am coinstantly getting calls that say they are from
I am coinstantly getting calls that say they are from Microsoft....I have others also trying to call about my computer. How do I know if it is really a call from Microsoft. They are always saying my c… read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
684 satisfied customers
I have bought a new Windows 10 and have used my Office 365
I have bought a new Windows 10 and have used my Office 365 sub to install Office suite. I now get a message for me to fix my account in order to continue using the software. What do I need to do? … read more
Cody
Cody
Computer Science
1,468 satisfied customers
I am trying to sign in to my Microsoft account...
I am trying to sign in to my Microsoft account...***@******.*** … read more
UranIT
UranIT
IT Consultant, Network and System Admin
Associate Degree
470 satisfied customers
I mistakenling uninstall microsoft office. Can I recover it?
I mistakenling uninstall microsoft office. Can I recover it? … read more
Viet - Computer Tech
Viet - Computer Tech
Computer Technican
Bachelor\u0027s Degree
952 satisfied customers
Uninstalled office 2011 for mac and then reinstalled from
uninstalled office 2011 for mac and then reinstalled from disk and outlook email not showing up … read more
Damian Costa
Damian Costa
Owner
Computer Network System Engineer
40 satisfied customers
I have an 8 column spreadsheet. A-H. Sorry, I hit enter too
Sorry, I hit enter too early. Excel. Not sure of the version … read more
The-PC-Guy
The-PC-Guy
Computer Manager
2,038 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x