Excel - Not retuning correct values.

[kyle20222022]

I am experiencing problems with a formula in a workbook we use in my workplace. It was written by a former employee who has recently left but taken the knowledge with him.

The data in cell 'BJ5' Should be the same as in 'BJ6'. BJ6 being the correct value.

I have attached a copy of the spreadsheet.

If anyone could help it would be of great help!

Regards

 

[kweaver]

Welcome to Mr. Excel.

You cannot attached files here. Best to show examples using XL2BB.

 

[Fluff]

Can you post some sample data.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[kyle20222022]

I am experiencing problems with a formula in a workbook we use in my workplace. It was written by a former employee who has recently left but taken the knowledge with him.

The data in cell 'BJ5' Should be the same as in 'BJ6'. BJ6 being the correct value.

I have attached a copy of the spreadsheet.

If anyone could help it would be of great help!

Regards

Can you post some sample data.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

ok I understand!.

I have installed the add on for xl2bb however whenever I try to capture a 'mini sheet' its freezes my excel and pops up shortly later with a message saying 'code interrupted'.

I have to close the workbook down and re open it. Any suggestions?.

Regards

Kyle Porter

 

[Fluff]

Do you have any named ranges that contain merged cells?