Hi community,

I’m working on a formula that searches a range of cells and outputs it another range of cells where the criteria are based on matches on two dropdown menus which are dependent (Columns A and B)

Summarized the formula does the following:

1. Lookup: Excel searches for a selected item from a corresponding dropdown menu in column B.

2. Retrieving Previous Data: When a match is identified (two identical items), Excel should search the designated columns to retrieve the previously entered data for that item.

3. Order of Retrieval: If there are multiple entries for the same item, Excel will prioritize the nearest entry relative to a reference row (This means below the reference row, it should not search upwards). For example, if the reference row is 11, and there are entries in rows 16 and 21 for the same item, Excel should retrieve the data from row 16. (You can test this by either blanking dropdown cells in columns A and B, and it will switch to the output location)

My problem is that I need this type of functionality across different sub-sheets so that when it starts searching in let’s say week 1 (sheet 1) it will continue its search parameters in week 2 (sheet 2) and maintain the order of retrieval as mentioned in point 3 above. Essentially linking different sub-sheets together through one formula.

I attached a sample with annotations to explain how the formula functions and how I need it to work.

The solutions I can think of are;

1. Simplyfing the formula making it less stress intensive so that it would be possible to merge all sub-sheets into one big sheet

2. Creating a master sheet where one can perform lookups using the INDIRECT and MATCH functions

I’m not sure how to fully flesh out these ideas or of other solutions however.

​Hi community,I’m working on a formula that searches a range of cells and outputs it another range of cells where the criteria are based on matches on two dropdown menus which are dependent (Columns A and B)Summarized the formula does the following:1. Lookup: Excel searches for a selected item from a corresponding dropdown menu in column B.2. Retrieving Previous Data: When a match is identified (two identical items), Excel should search the designated columns to retrieve the previously entered data for that item.3. Order of Retrieval: If there are multiple entries for the same item, Excel will prioritize the nearest entry relative to a reference row (This means below the reference row, it should not search upwards). For example, if the reference row is 11, and there are entries in rows 16 and 21 for the same item, Excel should retrieve the data from row 16. (You can test this by either blanking dropdown cells in columns A and B, and it will switch to the output location)=IF(B11=””,””,IFERROR(MAKEARRAY(5,3,LAMBDA(x,y,INDEX($G$1:$I$25,XLOOKUP(A11&B11,$A$5:$A$10&$B$5:$B$10,ROW($B$4:$B$9),,0,-1)+x,y))),””))My problem is that I need this type of functionality across different sub-sheets so that when it starts searching in let’s say week 1 (sheet 1) it will continue its search parameters in week 2 (sheet 2) and maintain the order of retrieval as mentioned in point 3 above. Essentially linking different sub-sheets together through one formula.I attached a sample with annotations to explain how the formula functions and how I need it to work.The solutions I can think of are;1. Simplyfing the formula making it less stress intensive so that it would be possible to merge all sub-sheets into one big sheet2. Creating a master sheet where one can perform lookups using the INDIRECT and MATCH functionsI’m not sure how to fully flesh out these ideas or of other solutions however.  Read More

​

Hi

I have written Azure Open AI implementation integrating with Azure cognitive search, as shown below. 

{
“data_sources”: [
{
“type”: “AzureCognitiveSearch”,
“parameters”: {
“endpoint”: “AZURE_SEARCH_END_POINT”,
“key”: “AZURE_SEARCH_KEY”,
“index_name”: “INDEX_NAME”,
“scope”: {
“in_scope”: true,
“top_n_documents”: 1
}
“queryType”:”vectorSimpleHybrid”,
}
}
],

 Then I make Azure Open API completion call using this Azure cognitive search service. I use mode GPT 3.5.

Everything is working fine as expected.

The challenge is the number of tokens it is generating is huge. For the simple prompt like “Who is Some XYZ”, it shows ‘4000+’ prompt tokens.

How do I avoid this. I am not adding any context to this. I tested taking out the above code and the prompt token count is around 5.

Can you suggest ways to solve this?

I tested adding filter to point to one chunkId, even then the prompt token count does not come down.

I was told to run a semantic search on to search index and then give the results as input chat completion API. But not sure how to implement this.

Can you suggest or point me the right direction.

REST API call would be preferred but even python code will help.

Thank you

​HiI have written Azure Open AI implementation integrating with Azure cognitive search, as shown below. {
“data_sources”: [
{
“type”: “AzureCognitiveSearch”,
“parameters”: {
“endpoint”: “AZURE_SEARCH_END_POINT”,
“key”: “AZURE_SEARCH_KEY”,
“index_name”: “INDEX_NAME”,
“scope”: {
“in_scope”: true,
“top_n_documents”: 1
}
“queryType”:”vectorSimpleHybrid”,
}
}
], Then I make Azure Open API completion call using this Azure cognitive search service. I use mode GPT 3.5.Everything is working fine as expected.The challenge is the number of tokens it is generating is huge. For the simple prompt like “Who is Some XYZ”, it shows ‘4000+’ prompt tokens.How do I avoid this. I am not adding any context to this. I tested taking out the above code and the prompt token count is around 5.Can you suggest ways to solve this? I tested adding filter to point to one chunkId, even then the prompt token count does not come down.I was told to run a semantic search on to search index and then give the results as input chat completion API. But not sure how to implement this.Can you suggest or point me the right direction.REST API call would be preferred but even python code will help. Thank you  Read More

​

My dad just warned me of the most recent windows 11 updated and he said not to update to it today as it bricked some laptops. Is this true? What have you heard about it?

​My dad just warned me of the most recent windows 11 updated and he said not to update to it today as it bricked some laptops. Is this true? What have you heard about it?  Read More

​

I am new to managing a Microsoft Partner account & was recently asked for the training release schedule. Specifically looking for information around the update to Endpoint Administrator (MD-102) exam course. I was told there used to be a way to get the course release dates but could not find anything on the partner site. If someone could help point me in the right direction, would greatly appreciate it. 

​I am new to managing a Microsoft Partner account & was recently asked for the training release schedule. Specifically looking for information around the update to Endpoint Administrator (MD-102) exam course. I was told there used to be a way to get the course release dates but could not find anything on the partner site. If someone could help point me in the right direction, would greatly appreciate it.   Read More

​

Dear Friends,

The DIVD11 ETF, available on the Brazilian stock exchange (BOVESPA), doesn’t appear in the “STOCKS” supplement of Excel. It seems that the asset needs to be updated. How to fix this?

​Dear Friends,The DIVD11 ETF, available on the Brazilian stock exchange (BOVESPA), doesn’t appear in the “STOCKS” supplement of Excel. It seems that the asset needs to be updated. How to fix this?  Read More

​

Hello community.
I have two account in Outlook, the first one created using Gmail and then accidently create a new one created in Outlook domain.
I want to merge them to use the one Outlook email alias.
Can somebody assist me with it?
Thanks

​Hello community.I have two account in Outlook, the first one created using Gmail and then accidently create a new one created in Outlook domain.I want to merge them to use the one Outlook email alias.Can somebody assist me with it?Thanks  Read More

​

I am trying to integrate Viva engage embed code on our website. It is working fine only in edge but not in chrome. Anything specific that I need to do to make it work in chrome and other browsers ?

​I am trying to integrate Viva engage embed code on our website. It is working fine only in edge but not in chrome. Anything specific that I need to do to make it work in chrome and other browsers ?  Read More

​

I recently started using MDVM and am trying to understand when a vulnerability was last seen on a device. When I zero in on a vulnerability (CVE) I see three dates Published On, First Detected, and Updated On:

Published On: which I believe is the date the CVE was published

First Detected: this is the date the vulnerability was first detected on the device

Updated On: this is where I am not sure what this means. 

Is this the last date the vulnerability was detected on the device? 

Is it the last the device was scanned? 

If no to a & b, then how do I know when the vulnerability was last seen by the scanner. then how do I know when the vulnerability was last seen by the scanner.  Is there a Last Date detected?

I have been researching this for a while but have not been able to find an answer to this point and am hopeful this community can assist!

Thanks in advance

Winston

​I recently started using MDVM and am trying to understand when a vulnerability was last seen on a device. When I zero in on a vulnerability (CVE) I see three dates Published On, First Detected, and Updated On:Published On: which I believe is the date the CVE was publishedFirst Detected: this is the date the vulnerability was first detected on the deviceUpdated On: this is where I am not sure what this means. Is this the last date the vulnerability was detected on the device? Is it the last the device was scanned? If no to a & b, then how do I know when the vulnerability was last seen by the scanner. then how do I know when the vulnerability was last seen by the scanner.  Is there a Last Date detected? I have been researching this for a while but have not been able to find an answer to this point and am hopeful this community can assist! Thanks in advanceWinston  Read More

​

Hi,

Since the last outlook update, me and my collegaues discovered a supper annoying but very useless feature.

So when we are writing an email and we make a typo, that we notice and try to correct. In torder to do that we (left)click in the word, where the typo is, the outlook gives us some inteligent suggestions what could be the correct word, but if you don’t choose any of those options (please note that in hungarian it is rarely accurate) but you try to manually correct the typo and hit the delete or backspace keys, to delete teh misspelled character, and outlook archives an email instead ( most of the users don’t notice they have archived an email, just that it didn’t deleted the character they wanted, so they hittinn the key a few more times resulting a bunch of emails being archived accidentally).

To some up, I click on the word where teh typo is, the cursor flashes at the place between the leters as it shoudl be the entire word is highlighted, I see the spellig suggestions and if I hit any of the backspace od delete keys it archives an email, just like it would think my coursor is not where I see it, but on my email list, point one of the emails.

Any idea how can I get rid of this feautre? 

​Hi,Since the last outlook update, me and my collegaues discovered a supper annoying but very useless feature. So when we are writing an email and we make a typo, that we notice and try to correct. In torder to do that we (left)click in the word, where the typo is, the outlook gives us some inteligent suggestions what could be the correct word, but if you don’t choose any of those options (please note that in hungarian it is rarely accurate) but you try to manually correct the typo and hit the delete or backspace keys, to delete teh misspelled character, and outlook archives an email instead ( most of the users don’t notice they have archived an email, just that it didn’t deleted the character they wanted, so they hittinn the key a few more times resulting a bunch of emails being archived accidentally).To some up, I click on the word where teh typo is, the cursor flashes at the place between the leters as it shoudl be the entire word is highlighted, I see the spellig suggestions and if I hit any of the backspace od delete keys it archives an email, just like it would think my coursor is not where I see it, but on my email list, point one of the emails. Any idea how can I get rid of this feautre?    Read More

​