Excel Functions requirement

[Kandavalli.Kiran]

Hi Team,

I need to implement the formulas in Summary Sheet Based on Other Sheets.

Yesterday Mike helped me with the same Kind of Scenarios. Mike if you see my request you can easily understand the logic

As an Example in the attached file I have created two sheets but in real scenario we have many Sheets. So we have to write Functions to fetch the results from various sheets

Total Tables Executed
---------------------

We need to count the distinct table names there in column B in all the sheets. Some Sheets might have more than 1 table name (for ex- In sheet 2 we have two tables CDE and XYZ in column B).
So I have mentioned as 3 in the attached Excel file.

Tables Excluded
---------------

We can ignore this for time being

NO OF TABLES WITH FAILED TEST CASES
----------------------------------------

We should Compare Column B with Column F in each sheet. If any of row mentioned as ‘Fail’ for a particular table we should count that table.

For Ex-
a) As per attached sheet we have 3 tables ABC, CDE, XYZ
b) In Sheet 1 for ABC table we have a FAIL in Column F, So we should consider ABC table into COUNT
c) In Sheet2 for CDE table we have all PASS in Column F, so we should not take this table into COUNT.
d) In Sheet2 for XYZ table we have a FAIL in Column F, So we should consider XYZ table into COUNT

Hence I have mentioned the count as 2 in the attached Excel file.

NAME OF THE TABLES WITH FAILED TEST CASE
----------------------------------------------

In above we are showing the Count – here we will show the table name which have at least One FAIL.
The Table name can be fetched from column B from each sheet.
The Table names should be shown one below the other like

ABC
XYZ

ANALYSIS
---------

It is a Concatenation of all Test Cases which got failed.
The Concatenation should be based on COLUMN B / COLUMN C / COLUMN G and each test case need to be shown one below the Other.
While Concatenating COLUMN G we have to bold the Text – SOURCE , TARGET & DATA MISMATCH as it has to be as mentioned in Excel File.

Reference File
-------------

Attached below

1) Excel file is for implementation
2) Word Doc is for Explanation

Thanks!
Kiran

[alansidman]

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)