formula modification

Good day all,

I am having a problem with a formula that someone gave me and wondering if anyone can help me. the columns were changed and couldn't change the formula accordingly. the problem is with the green and blue table, in AllAlerts sheet, that sorts the data from PendingAlerts sheet.I attached the old sheet to see how it used work and the new sheet now.
thank you in advance for your great support

To attach a file to your post, you need to be using the main 'New Post' or 'New Thread' page and not 'Quick Reply'.
To use the main 'New Post' page, click the 'Post Reply' button in the relevant thread.

On this page, below the message box, you will find a button labelled 'Manage Attachments'.
Clicking this button will open a new window for uploading attachments.

You can upload an attachment either from your computer or from another URL by using the appropriate box on this page.
Alternatively you can click the Attachment Icon to open this page.

To upload a file from your computer, click the 'Browse' button and locate the file.

To upload a file from another URL, enter the full URL for the file in the second box on this page.
Once you have completed one of the boxes, click 'Upload'.

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Hi,

Maybe try zipping the file and attaching to the original thread. I downloaded the file, but couldn't open it because it .rar and not .zip.

abousetta

Hi,

I think I got the right references in the new formulas, but please double check that the numbers are what they should be.

abousetta

Here is a modified version.

Good luck.

abousetta

massar200, please don't quote whole posts

Hi,

Could you identify which cell this having a problem in and what you expected the correct answer should be? That way I can modify and check the modifications.

Thanks.

abousetta

Hi,

I have updated your formulas to check column K instead of H and B instead of A. I'm not seeing a difference in the results and I don't know what the results are supposed to because there are no entries in Column B marked as 'critical'.

Have a look and tell me if the formulas still need a tweak. If so, maybe add some more data and tell me what the expected results should be.

Thanks.

abousetta

Sorry. I guess I forgot to upload it. I have added it with my previous post.

Ahmed

There is a discrepancy between what you are looking for in the formula and what is in your actual data tables. For example there is an underscore after SAP in the formula but a space in the data tables. You need to make sure that they are both the same. Also the extension after SAP in the example you provided is not found in the data tables:

Formula check for:

Please Login or Register  to view this content.

Data tables contain:

Please Login or Register  to view this content.

Once you standardize these then you should get the right results, but right now I can't tell how you came up with the number 3 for F85.

abousetta

You are right. I wrote the wrong letter in the post, but the formulas are looking at Column K, but still same problem as before since there is no match.

abousetta

Glad it all worked out. Thanks for marking the thread as Solved.

abousetta