Hi,
I am looking for a formula and macro for the attached condition.
Can some one please help me in creating this.
It is very urgent and I have been struggling to create this.
Request you please help me in creating.
Have attached the requirement criteria and worksheet.
Thanks,
Stella
Last edited by stella_j; 04-18-2016 at 09:30 AM.
Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.
Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
Never use Merged Cells in Excel
I have done necessary changes zbor. Can any expert reply for my requirement
Hopefully someone will give you solution soon.
As per the attached excel, below is the requirement: -
Main Reports sheet:
1.Formula to update column E “Defects Fixed” based on column D value –
Match the value of column D of Main Reports sheet with the value in column A of Daily Defects sheet, if column B in Daily Defects sheet is “Fixed” then input the highest Severity value of column C from Daily Defects sheet into column E of Main Reports sheet.
For Example-
BusinessImpact
(move over daily + Sort by Status 2, Defect Id, Severity Status 2 Severity
B Fixed 2 - Critical
B Fixed 1 - Show Stopper
In this case it should populate “1 - Show Stopper” i.e. in the Severity sequence of 1,2,3,4; the highest value should be displayed it means if the Severity is displayed as 2 and 3 then 2 should be displayed
2. Formula to update column F “Defects To Fix” based on column D value –
Match the value of column D of Main Reports sheet with the value in column A of Daily Defects sheet, if column B in Daily Defects sheet is “To be Fixed” then input the highest Severity value of column C from Daily Defects sheet into column F of Main Reports sheet.
For Example-
BusinessImpact (move over daily + Sort by Status 2, Defect Id, Severity Status 2 Severity
C To be Fixed 1 - Show Stopper
C To be Fixed 2 - Critical
In this case it should populate “1 - Show Stopper” i.e. in the Severity sequence of 1,2,3,4; the highest value should be displayed it means if the Severity is displayed as 2 and 3 then 2 should be displayed
Need a Macro or formula to populate Reports Unique list sheet
Based on column B “Unique list” in Main Reports sheet look for unique numbers and populate its first row data in the Reports Unique list sheet.
For Example-
In Main Reports sheet
Unique list Apex Report Name Defects Fixed Defects To fix
1 B 1 - Show Stopper
3 D
5 F
7 H
It should display the data of first row in the Reports Unique list shee
===Attaching both the sheet (local excel which contains all the 3 tabs or worksheet) & (a detailed requirement document called "Urgently needed implementation".
This looks to me like one for the Commercial Services section: http://www.excelforum.com/payments.php
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Volunteer organiser & photographer with the Sutton Hoo Ship's Company: https://saxonship.org/
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
no its not a commercial Services. its just a requirement..
Last edited by stella_j; 04-18-2016 at 09:29 AM.
What do you mean by "just a requirement"? You seem to be asking for a complete solution. Looking at your attached sheet, you haven't done any of the work yourself.
I have done all the hardwork but since iam a newbee in excel wanted your guidance and support... Moreover if i would have had the solution, i would closed the issue.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks