Forum

Forums
Public Forums - For...
General Excel Quest...
BOE
 
Notifications
Clear all

[Solved] BOE

 
General Excel Questions & Answers
Last Post by Md Saliha 2 months ago
5 Posts
2 Users
0 Reactions
274 Views
RSS
Md Saliha
 Md Saliha
(@navsal66)
Posts: 123
Estimable Member
Topic starter
 

Hi All,

i have a combined invoice detaisl with BOE no. in one sheet, an other coloumn i have updated manually invoice there is any formula to pick BOE no based on megerged invoices

BOE.xlsx

 

This topic was modified 2 months ago by Md Saliha
 
Posted : 05/05/2025 3:45 pm
Riny van Eekelen
 Riny van Eekelen
(@riny)
Posts: 1256
Member Moderator
 

@navsal66

I believe this does what you need.

=FILTER($C$4:$C$11,ISNUMBER(FIND(E4,$B$4:$B$11)),"-")

BOE.xlsx
 
Posted : 05/05/2025 4:29 pm
Md Saliha
 Md Saliha
(@navsal66)
Posts: 123
Estimable Member
Topic starter
 

Hi Riny,

filter option not working in my version (2019), can you give me please other example.

 
Posted : 06/05/2025 3:18 pm
Riny van Eekelen
 Riny van Eekelen
(@riny)
Posts: 1256
Member Moderator
 

@navsal66 

Try this one:

=SUMPRODUCT(--ISNUMBER(FIND(E4,$B$4:$B$11))*$C$4:$C$11)

 
Posted : 06/05/2025 6:39 pm
Md Saliha
 Md Saliha
(@navsal66)
Posts: 123
Estimable Member
Topic starter
 

Thanks Riny its working fine

 
Posted : 06/05/2025 7:17 pm
Forum Jump:
  Previous Topic
Next Topic  
Share: