Excel Forum - Recent Posts

RE: WhatsApp

Mynda Treacy — Thu, 11 Jun 2026 22:32:13 +0000

Hi Eileen,

As per my reply to you on YouTube, you'd have to check the WhatsApp API rules. This forum is for Excel questions, that is we're Excel experts, not WhatsApp experts, so we don't know. There may be a WhatsApp forum where someone might know the answer if you can't find it in the API documentation.

All the best,

Mynda

Eileen McCarthy — Thu, 11 Jun 2026 15:47:35 +0000

Hi Mynda, on the Taining Hub Video "Send Personalized WhatsApp Reminders from Excel in Seconds", is it possible to send over 2000 every month by whatsApp?

RE: Add multiple bill of materials assemblies to inventory management

Pakayak — Sat, 06 Jun 2026 17:27:27 +0000

Perfect, thank you!

RE: Add multiple bill of materials assemblies to inventory management

Riny van Eekelen — Sat, 06 Jun 2026 04:28:24 +0000

@pakayak

Since you want to look for the ProductID and the Site, it's easier to use to use FILTER as it allows you to combine filter criteria by + (OR) or * (AND).

Based on the Inventor file you attached earlier, this formula should work:

=SUM(FILTER('Inventory Sample.xlsx'!Inventory,('Inventory Sample.xlsx'!Inventory=)*('Inventory Sample.xlsx'!Inventory="Integrity"),0))

I've wrapped it in a SUM so that it can be used inside a structured table. It will return the Qty on hand for the ProductID at "Integrity".

Now, you can use XLOOKUP, but then you need to concatenate the two criteria into one lookup value and do the same for the lookup array. It works but it quickly gets messy IMHO.

=XLOOKUP("Integrity"&,'Inventory Sample.xlsx'!Inventory&'Inventory Sample.xlsx'!Inventory,'Inventory Sample.xlsx'!Inventory,0)

RE: Add multiple bill of materials assemblies to inventory management

Pakayak — Fri, 05 Jun 2026 20:46:23 +0000

We need help with an XLOOKUP formula that's not working. Trying to have a column in the BOM gather the inventory quantity from the Inventory sheet when Site = "Integrity" but it's giving #N/A. I've tried several versions but can't get it to work. Here's the formula: =XLOOKUP(B3,(inventory_management_system.xlsx!Inventory)*(inventory_management_system.xlsx!Inventory="Integrity"),inventory_management_system.xlsx!Inventory)/[@] Hoping you can help. Thanks!!

RE: Alerting on decreasing values over multiple dates

Riny van Eekelen — Thu, 04 Jun 2026 14:46:15 +0000

@alanr

@velouria Proved me wrong :)

RE: Alerting on decreasing values over multiple dates

Alan Ramsay — Thu, 04 Jun 2026 14:30:04 +0000

@debaser Hi Velouria, many thanks for this - I added your formula to my main table and it appears to be working well! I'll test it out a little more thoroughly over the coming days, very helpful though, thank you.

RE: Alerting on decreasing values over multiple dates

Alan Ramsay — Thu, 04 Jun 2026 14:28:24 +0000

@riny Hi Riny, many thanks for taking the time to look at this in such detail. I should have thought to look at PowerQuery for this problem, I am going to do that now. Though Velouria's formula appears to be working. Thanks again.

RE: Alerting on decreasing values over multiple dates

Velouria — Thu, 04 Jun 2026 07:41:01 +0000

If your data doesn't have missing date/station combinations, and is sorted as in your sample, then I think something like this would work:

=IF($J2="","",LET(_data,TAKE(FILTER($T$2:$T2,$J$2:$J2=$J2),-3),IF(ROWS(_data)<3,"",SUM((TAKE(_data,-2)

It returns "" if there aren't three or more dates to check, FALSE if the last three dates are not all decreasing, and TRUE if they are. Only lightly tested though!

RE: Alerting on decreasing values over multiple dates

Riny van Eekelen — Thu, 04 Jun 2026 05:00:13 +0000

@alanr

Your file is full with links to your Sharepoint site and these will obviously not update for us. I've copied the table and pasted it back as values. Then I only kept the three relevant columns, deleted all rows with blank or #NA BV values. Then a simple pivot table and a helper function outside it will give you the alert you need (TRUE or FALSE)

However, I found no stations that had decreasing BV values for three consecutive days in a row. So, I just faked a few numbers to test the concept.

The attached file contains this, perhaps a bit clunky, solution. If you need to do this very frequently and on much larger data sets you may want to choose a more sturdy approach. That is, connect to the data with PowerQuery (transformed into what I did manually) and pivot the data. Load back to Excel add the check-formula in separate (calculated) column.

A single formula solution in the BVC Check column with the data shaped as you have it will be difficult if not impossible, I believe.

783