Category: News
To find the Missing rows
Every CEO should have both ‘SEYT’ and ‘ZZZZ’ records in Acc_Personal. I want to find any CEO record if anyone is missing ‘ZZZZ’ record. See table below.
CREATE TABLE DBO.TMP (CEO VARCHAR(20), Acc_Personal VARCHAR(20), AMT INT, DATEA DATETIME, STAT VARCHAR(1))
INSERT INTO DBO.TMP VALUES (‘10001′,’SEYT’,78, ‘2024-04-09′,’N’
INSERT INTO DBO.TMP VALUES (‘10001′,’ZZZZ’,12, ‘2024-03-09′,’N’
INSERT INTO DBO.TMP VALUES (‘10002′,’SEYT’,45, ‘2024-06-02′,’N’
INSERT INTO DBO.TMP VALUES (‘10002′,’ZZZZ’,55, ‘2024-07-07′,’D’
INSERT INTO DBO.TMP VALUES (‘10003′,’SEYT’,76, ‘2024-08-09′,’N’
INSERT INTO DBO.TMP VALUES (‘10004′,’SEYT’,45, ‘2024-04-02′,’C’
INSERT INTO DBO.TMP VALUES (‘10004′,’ZZZZ’,21, ‘2024-07-09′,’N’
INSERT INTO DBO.TMP VALUES (‘10005′,’SEYT’,57, ‘2024-04-01′,’N’
INSERT INTO DBO.TMP VALUES (‘10006′,’SEYT’,59, ‘2024-04-01′,’B’
INSERT INTO DBO.TMP VALUES (‘10006′,’SEYT’,47, ‘2024-02-01′,’A’
INSERT INTO DBO.TMP VALUES (‘10007′,’SEYT’,59, ‘2024-04-09′,’N’
Desired Output
—————–
CEO Acc_personal AMT DATEA STAT
1003
1005
1007
Every CEO should have both ‘SEYT’ and ‘ZZZZ’ records in Acc_Personal. I want to find any CEO record if anyone is missing ‘ZZZZ’ record. See table below. CREATE TABLE DBO.TMP (CEO VARCHAR(20), Acc_Personal VARCHAR(20), AMT INT, DATEA DATETIME, STAT VARCHAR(1)) INSERT INTO DBO.TMP VALUES (‘10001′,’SEYT’,78, ‘2024-04-09’,’N’INSERT INTO DBO.TMP VALUES (‘10001′,’ZZZZ’,12, ‘2024-03-09’,’N’INSERT INTO DBO.TMP VALUES (‘10002′,’SEYT’,45, ‘2024-06-02’,’N’INSERT INTO DBO.TMP VALUES (‘10002′,’ZZZZ’,55, ‘2024-07-07’,’D’INSERT INTO DBO.TMP VALUES (‘10003′,’SEYT’,76, ‘2024-08-09’,’N’INSERT INTO DBO.TMP VALUES (‘10004′,’SEYT’,45, ‘2024-04-02’,’C’INSERT INTO DBO.TMP VALUES (‘10004′,’ZZZZ’,21, ‘2024-07-09’,’N’INSERT INTO DBO.TMP VALUES (‘10005′,’SEYT’,57, ‘2024-04-01’,’N’INSERT INTO DBO.TMP VALUES (‘10006′,’SEYT’,59, ‘2024-04-01’,’B’INSERT INTO DBO.TMP VALUES (‘10006′,’SEYT’,47, ‘2024-02-01’,’A’INSERT INTO DBO.TMP VALUES (‘10007′,’SEYT’,59, ‘2024-04-09′,’N’ Desired Output—————–CEO Acc_personal AMT DATEA STAT100310051007 Read More
Microsoft 365 and Microsoft Office 2024 LTSC support on Windows Server 2025
For now, it is not clear if Microsoft 365 apps shall be supported on Windows Server 2025, at least during the mainstream support of the OS, although earlier there statements that said that they will be supported.
Microsoft Office 2024 LTSC does not include Windows Server 2025 as a supported OS. Would this mean it shall not be installable? Perhaps a the limited Microsoft 365 model shall be applied? I am interested in having office apps installed for offline use, on demand, on Windows Server 2025. Are there any clear and recent information on this topic?
For now, it is not clear if Microsoft 365 apps shall be supported on Windows Server 2025, at least during the mainstream support of the OS, although earlier there statements that said that they will be supported.Microsoft Office 2024 LTSC does not include Windows Server 2025 as a supported OS. Would this mean it shall not be installable? Perhaps a the limited Microsoft 365 model shall be applied? I am interested in having office apps installed for offline use, on demand, on Windows Server 2025. Are there any clear and recent information on this topic? Read More
Is code generation supported for “convolution1DLayer”?
Is code generation supported for "convolution1DLayer"?Is code generation supported for "convolution1DLayer"? Is code generation supported for "convolution1DLayer"? code, generation, convolution1dlayer, convolution, 1d, layer, deep, learning, neural, network, matlab, coder, spatial, temporal MATLAB Answers — New Questions
gwagwagagwa wag wa aggwagw
gwawagaggwawagag gwawagag thingspeak MATLAB Answers — New Questions
Having partial text in a cell change to bold.
I’m trying to have Excel bold the text after “MM ” in a cell. I would like to have it do this for the entire range. Right now I’m doing it manually. Here is an image of my worksheet.
Any help would be appreciated.
Thank you.
Scott
I’m trying to have Excel bold the text after “MM ” in a cell. I would like to have it do this for the entire range. Right now I’m doing it manually. Here is an image of my worksheet.Any help would be appreciated.Thank you.Scott Read More
Number format problem for large amounts of tim
I have a table with per line; Article (text), Quantity (integer or default value), unit time (in hours and minutes), total time (in number of months, number of days, number of hours, and number of minutes). The unit time can be 1 min, 5 min, 1 hour, 3 hours or 8 hours (1 table line per unit time quantity). The total time of the line is equal to the quantity multiplied by the unit time. Of course, at the bottom of the column, I add the total sum of all time totals for each line. The problem that arises concerns the format of the numbers for the time totals. It’s one of two things.
If my total time is greater than 31 days and I have used a customized format without the number of months, the number of days displayed will be equal to the number of days exceeding the number of full months (for example, if my total is 33 days, the number of days displayed will be 2 (2 days beyond the 31-day month).
If this is not the case, there are two possible outcomes:
– If my customized format includes the number of months, the number of months is automatically set to 1, even if the cumulative time of my line is only one minute. Furthermore, if the accumulated time exceeds 1 month by even one minute, the number of months displayed will be 2, and so on.
– If my cumulative time is greater than 31 days and I’ve used a custom format without the number of months, the number of days displayed will be equal to the number of days exceeding the number of full months (e.g. if my total is 33 days, the number of days displayed will be 2 (2 days beyond the 31-day month).
Hence my question: Is there a simple way of solving this problem?
I have a table with per line; Article (text), Quantity (integer or default value), unit time (in hours and minutes), total time (in number of months, number of days, number of hours, and number of minutes). The unit time can be 1 min, 5 min, 1 hour, 3 hours or 8 hours (1 table line per unit time quantity). The total time of the line is equal to the quantity multiplied by the unit time. Of course, at the bottom of the column, I add the total sum of all time totals for each line. The problem that arises concerns the format of the numbers for the time totals. It’s one of two things. If my total time is greater than 31 days and I have used a customized format without the number of months, the number of days displayed will be equal to the number of days exceeding the number of full months (for example, if my total is 33 days, the number of days displayed will be 2 (2 days beyond the 31-day month). If this is not the case, there are two possible outcomes:- If my customized format includes the number of months, the number of months is automatically set to 1, even if the cumulative time of my line is only one minute. Furthermore, if the accumulated time exceeds 1 month by even one minute, the number of months displayed will be 2, and so on.- If my cumulative time is greater than 31 days and I’ve used a custom format without the number of months, the number of days displayed will be equal to the number of days exceeding the number of full months (e.g. if my total is 33 days, the number of days displayed will be 2 (2 days beyond the 31-day month). Hence my question: Is there a simple way of solving this problem? Read More
Help to find in sequence issue in groups records
Hi, Every group_cost has different sequence of PP_Seq but it should not be any gap in the sequence of any group_cost rcords. It should always be increment by 1. I want to see any record/row of any group_cost if it has any issue in pp_seq and not increment by 1. I want to see when the issue of sequence is started then it will be corrected with other next rows.
Create table #Cost (group_cost char(10), PP_Seq int, date1 datetime, ST char(2))
insert into #cost (‘T1′,5,’2023-01-01′,’A’)
insert into #cost (‘T1′,6,’2023-02-01′,’A’)
insert into #cost (‘T1′,7,’2023-03-01′,’A’)
insert into #cost (‘T2′,12,’2023-01-01′,’A’)
insert into #cost (‘T2′,14,’2023-02-01′,’B’) — This pp_seq is not increment by 1. Should be in output
insert into #cost (‘T2′,15,’2023-03-01′,’A’)
insert into #cost (‘T3′,25,’2023-01-02′,’A’)
insert into #cost (‘T3′,26,’2023-02-01′,’A’)
insert into #cost (‘T3′,27,’2023-03-05′,’A’)
insert into #cost (‘T5′,65,’2023-01-01′,’A’)
insert into #cost (‘T5′,66,’2023-02-06′,’A’)
insert into #cost (‘T5′,67,’2023-03-04′,’W’)
insert into #cost (‘T5′,69,’2023-04-01′,’A’) — This pp_seq is not increment by 1. Should be in output
–Expected result
group_cost PP_Seq date1 ST Comments
T2 14 2023-02-01 B PP_Seq is not in seq. Also check next rows to correct.
T5 69 2023-04-01 A PP_Seq is not in seq. Also check next rows to correct.
Hi, Every group_cost has different sequence of PP_Seq but it should not be any gap in the sequence of any group_cost rcords. It should always be increment by 1. I want to see any record/row of any group_cost if it has any issue in pp_seq and not increment by 1. I want to see when the issue of sequence is started then it will be corrected with other next rows. Create table #Cost (group_cost char(10), PP_Seq int, date1 datetime, ST char(2))insert into #cost (‘T1′,5,’2023-01-01′,’A’)insert into #cost (‘T1′,6,’2023-02-01′,’A’)insert into #cost (‘T1′,7,’2023-03-01′,’A’) insert into #cost (‘T2′,12,’2023-01-01′,’A’)insert into #cost (‘T2′,14,’2023-02-01′,’B’) — This pp_seq is not increment by 1. Should be in output insert into #cost (‘T2′,15,’2023-03-01′,’A’) insert into #cost (‘T3′,25,’2023-01-02′,’A’)insert into #cost (‘T3′,26,’2023-02-01′,’A’)insert into #cost (‘T3′,27,’2023-03-05′,’A’) insert into #cost (‘T5′,65,’2023-01-01′,’A’)insert into #cost (‘T5′,66,’2023-02-06′,’A’)insert into #cost (‘T5′,67,’2023-03-04′,’W’)insert into #cost (‘T5′,69,’2023-04-01′,’A’) — This pp_seq is not increment by 1. Should be in output –Expected resultgroup_cost PP_Seq date1 ST CommentsT2 14 2023-02-01 B PP_Seq is not in seq. Also check next rows to correct. T5 69 2023-04-01 A PP_Seq is not in seq. Also check next rows to correct. Read More
Indexing/Accessing Entire Columns of Nested Array
I have a nested cell array {48×691}. I would like to isolate an entire column of the nested cell array while grabbing all of the rows such that I would get the nested arrays in this way:
{:,1} {:, 2} {:,3} … {:,691}
In other words, how do I get all of the 691 columns from the nested array extracted such that I grab the 48 rows each time?
Thank you!I have a nested cell array {48×691}. I would like to isolate an entire column of the nested cell array while grabbing all of the rows such that I would get the nested arrays in this way:
{:,1} {:, 2} {:,3} … {:,691}
In other words, how do I get all of the 691 columns from the nested array extracted such that I grab the 48 rows each time?
Thank you! I have a nested cell array {48×691}. I would like to isolate an entire column of the nested cell array while grabbing all of the rows such that I would get the nested arrays in this way:
{:,1} {:, 2} {:,3} … {:,691}
In other words, how do I get all of the 691 columns from the nested array extracted such that I grab the 48 rows each time?
Thank you! indexing nested cell array, nested cell array, indexing MATLAB Answers — New Questions
Work Around for Convolution1DLayer
I am trying to do code generation of a trained deep learning network however it uses a convolution1dlayer. It seems this is not currently supported by matlab. What are some possible solutions to this problem?I am trying to do code generation of a trained deep learning network however it uses a convolution1dlayer. It seems this is not currently supported by matlab. What are some possible solutions to this problem? I am trying to do code generation of a trained deep learning network however it uses a convolution1dlayer. It seems this is not currently supported by matlab. What are some possible solutions to this problem? deep learning, code generation MATLAB Answers — New Questions
sharepoint dlp policies not detecting pdf files with label
Hello Everyone,
I have a Microsoft purview sharepoint DLP policy with a following condition.
I have targeted this to sharepoint online workload and specific site. I have labeled a file using Microsoft purview information protection client in windows explorer and same has been uploaded to sharepoint site(that is in scope of the policy). whenever I am trying to share the pdf file labeled with (confidential / All users encrypted) it is not getting blocked.
Please let me know if I am missing something related to sharepoint.
Note: There is no encryption settings in label, it is just a name.
Notify users with email and policy tips
Restrict access to the content for external users
Send alerts to Administrator
Hello Everyone, I have a Microsoft purview sharepoint DLP policy with a following condition. I have targeted this to sharepoint online workload and specific site. I have labeled a file using Microsoft purview information protection client in windows explorer and same has been uploaded to sharepoint site(that is in scope of the policy). whenever I am trying to share the pdf file labeled with (confidential / All users encrypted) it is not getting blocked.Please let me know if I am missing something related to sharepoint. Note: There is no encryption settings in label, it is just a name. ConditionsContent contains any of these sensitive info types: U.S. Social Security Number (SSN), Credit Card Number, Content contains any of these sensitivity labels: Confidential/All Users (Encrypted)Evaluate predicate for Message or attachmentAndContent is shared from Microsoft 365 with people outside my organizationActionsNotify users with email and policy tipsRestrict access to the content for external usersSend alerts to AdministratorOn Read More
Transferring Your Azure Subscription to a New Microsoft Entra ID
Could FastTrack assist in the scenario of Transferring an Azure Subscription to a New Microsoft Entra ID
Could FastTrack assist in the scenario of Transferring an Azure Subscription to a New Microsoft Entra ID Read More
Resize my Powerpoint Presentation
I am trying to resize my PPT and I was able to resize it in my previous file. I have a page of text from a book that is the basis of the page but the headings were corrupted so I added text boxes with new headings. I was able to make 3 new sizes of the PPT and it automatically adjusted the text box sizes and the fonts within it to the new size. Now when I try it the text box shrinks but the font stays the same size.
How can I shrink the whole page with multiple text boxes and fonts so that everything adjusts at once? Need assistance on this at the earliest possible!
I am trying to resize my PPT and I was able to resize it in my previous file. I have a page of text from a book that is the basis of the page but the headings were corrupted so I added text boxes with new headings. I was able to make 3 new sizes of the PPT and it automatically adjusted the text box sizes and the fonts within it to the new size. Now when I try it the text box shrinks but the font stays the same size. How can I shrink the whole page with multiple text boxes and fonts so that everything adjusts at once? Need assistance on this at the earliest possible! Read More
Recommendations to set up complex permissions site and library
We have a process in SP2016 where one collection has about 200 subsites and another similar collection about 50 subsites. Each subsite is for 1 user, some profile data, and their documents. A couple times a year a group of subsites need to have read access for three other employees (3 different per subsite, not 3 for the group of subsites). After about a month, these permissions are removed. This is a very manual process. This system needs to be converted to SPO, but subsites are not permitted and since the subsite template may change, does not seem appropriate. My process has been to create a record per user, linked to a folder per user and accessed via a PowerApp. I have some workflows to help manage permissions, but it’s not comprehensive yet. I’m interested in finding out how someone else would tackle this migration, keeping in mind that ultimately it is managed by non-tech HR staff. Thank You!
We have a process in SP2016 where one collection has about 200 subsites and another similar collection about 50 subsites. Each subsite is for 1 user, some profile data, and their documents. A couple times a year a group of subsites need to have read access for three other employees (3 different per subsite, not 3 for the group of subsites). After about a month, these permissions are removed. This is a very manual process. This system needs to be converted to SPO, but subsites are not permitted and since the subsite template may change, does not seem appropriate. My process has been to create a record per user, linked to a folder per user and accessed via a PowerApp. I have some workflows to help manage permissions, but it’s not comprehensive yet. I’m interested in finding out how someone else would tackle this migration, keeping in mind that ultimately it is managed by non-tech HR staff. Thank You! Read More
Exchange Hybrid to Exchange Online – AD Sync enabled
Hi All,
I have a scenario with two redudants exchanges 2019 onprem and Office 365.
All mailboxes are hosted in cloud and we are using no smtp in onprem server.
Is there a known process to proceed with decomm of onprem server? Does the Microsoft cover this process?
Just did some researches and AD Sync could be a issue to proceed with this migration.
Thanks in advance
Hi All,I have a scenario with two redudants exchanges 2019 onprem and Office 365.All mailboxes are hosted in cloud and we are using no smtp in onprem server. Is there a known process to proceed with decomm of onprem server? Does the Microsoft cover this process?Just did some researches and AD Sync could be a issue to proceed with this migration. Thanks in advance Read More
Comment Threshold using Question Responses Filter
Has anybody else run into this? I opened a ticket because comments were being suppressed even if there were 10+ respondents when using ‘Question Response’ filters. Our threshold is 10. The engineering team said that ‘Question Response’ threshold are always 20 for comments regardless thresholds set in configuration. Why would the threshold configuration work for some filters but not others?! I can’t find documentation either. Anyone else?
Has anybody else run into this? I opened a ticket because comments were being suppressed even if there were 10+ respondents when using ‘Question Response’ filters. Our threshold is 10. The engineering team said that ‘Question Response’ threshold are always 20 for comments regardless thresholds set in configuration. Why would the threshold configuration work for some filters but not others?! I can’t find documentation either. Anyone else? Read More
Bridging the On-premises to Cloud Security Gap: Cloud Credentials Detection
Identities lie at the heart of cloud security. One of the most common tactics used to breach cloud environments is Credential Access. User credentials may be obtained using various techniques. Credentials may be cracked through brute force attempts, obtained in social engineering campaigns, or stolen from compromised resources, where they are stored fand used.
In this blog, we demonstrate that properly securing cloud environments requires securing credentials in the organization’s non-cloud environments. To this end, we dive into our innovative capability to detect cloud credentials in on-premises environments and user devices. By integrating it with Microsoft Security Exposure Management, customers are able to identify attack paths starting in non-cloud environments and reaching critical cloud assets using cloud credentials. Customers are then able to effectively prioritize and mitigate those attack paths, thereby improving their enterprise and cloud security posture.
Credentials in On-premises Environments and User Devices: the Achilles Heel of Cloud Security
Awareness of the risk of credential theft in cloud environments is increasing, with security vendors offering secret scanning in various cloud-based resources, such as virtual machines and code repositories. However, cloud-credential theft from on-premises environments and user devices is a substantial blind spot in cloud protection solutions.
Consider the following attack scenario: To work with cloud infrastructures, employees must constantly use credentials on their personal computers. Most predominantly, users access cloud provider services either using the web portal or a CLI tool. Both methods can leave long-term credentials on the employee’s computer, such as authentication cookies and access tokens. A malicious actor who gains access to the user’s computer can easily steal those credentials and breach the customer’s cloud environment. The attacker immediately gains all the current permissions of the compromised user.
This scenario is a reality that we witness over and over with our customers. Our security research team has recently uncovered a crypto mining campaign targeting a large financial organization. The attack began by executing malware on an endpoint machine used by one of the organization’s administrators. The attacker then extracted a browser cookie from the compromised machine, which allowed them to bypass MFA and gain an initial foothold in the cloud environment with global administrator permissions.
The Technical Challenge: Identifying and Mapping Browser Cookies
The most widespread credential type that is used to access the cloud from user devices are authentication cookies. When logging in to a cloud provider’s website, authentication cookies are saved on the user’s browser to enable easy, password-free access in future sessions.
While the exact format varies, these cookies appear as long, randomized strings, and do not contain any identifier of the user that they be used to authenticate as. This poses a significant challenge to the security vendor, who needs to infer this exact connection.
The trivial way to solve the challenge this out would be to collect the authentication cookie from the user’s machine, and actively send it to the relevant website. This solution has several disadvantages which make it complex and unattractive:
Authentication cookies are highly sensitive secrets. Collecting and saving those cookies adds an unwanted risk to the customer.
Actively sending the cookies on a mass scale may look suspicious and cause false alarms on the website’s side.
High operational and engineering costs on the vendor’s side.
The Solution: Smart Analysis of Browser Artifacts
To overcome this challenge, we have come up with an innovative solution that is based on analysis of browser artifacts. The artifacts, saved by the website upon successful user authentication, contain the identifier of the authenticated user. This solution also provides information on the cookie’s validity, as the artifacts also indicate when a user logs out, or when a cookie is expired due to lack of usage.
The analysis runs periodically over Microsoft Defender for Endpoint and supports detection of both Azure Portal and AWS Console authentication cookies. On the first release, all Chromium-based browsers are supported.
In addition, we’re introducing an ability to detect cloud secrets used by the CLI tools of Azure, AWS and GCP. These secrets are stored locally and include refresh tokens, certificates, and access keys. Here, too, we’re able to correlate them to the relevant user that they can be used to authenticate as.
Reducing the Attack Surface and Enhancing Threat Detection
This new ability to detect cloud credentials in on-premises environments and user devices is fully integrated into Microsoft Security Exposure Management. This comes in addition to our existing abilities to detect credentials in cloud and hybrid environments. By ingesting the data to the exposure graph, customers are now able to:
Gain Visibility to the Attack Surface created by Cloud Credentials: Effectively prioritize protection on critical areas of the network which should be better protected.
Reduce the Attack Surface: Identify and mitigate attack paths involving cloud credentials.
Enhance Threat Detection of Hybrid Attacks: Having knowledge of the connection between on-premises and cloud environments provides important context in threat detection, enhancing detection and response of hybrid attack incidents.
Below is a screenshot from the Exposure Management user interface showing an on-premises to cloud attack scenario involving cloud credentials. The scenario begins with a vulnerable on-premises machine, which contains a browser cookie of an Azure user with the global administrator role. The cookie may be used to access a sensitive Azure storage account, which contains customer credit card details. This scenario and many more will soon be available in Microsoft Security Exposure Management.
Learn More
Dive into Exposure Management in our blog series
Announcing new CNAPP capabilities in Defender for Cloud
Contextual Risk Estimation for Effective Prioritization
Start Using Microsoft Security Exposure Management
Microsoft Tech Community – Latest Blogs –Read More
Can I run protected Simulink models in External mode before R2023b?
I am trying to run a Simulink mode via External Mode. Part of my model is a Protected Model Reference and I am using a release before release MATLAB R2023b.
If I attempt to run this model in External Mode it fails with the following error message:
Protected models do not work in External mode or rapid accelerator simulations.
Is it possible to protect a model and still be able to run it in External mode on these releases?I am trying to run a Simulink mode via External Mode. Part of my model is a Protected Model Reference and I am using a release before release MATLAB R2023b.
If I attempt to run this model in External Mode it fails with the following error message:
Protected models do not work in External mode or rapid accelerator simulations.
Is it possible to protect a model and still be able to run it in External mode on these releases? I am trying to run a Simulink mode via External Mode. Part of my model is a Protected Model Reference and I am using a release before release MATLAB R2023b.
If I attempt to run this model in External Mode it fails with the following error message:
Protected models do not work in External mode or rapid accelerator simulations.
Is it possible to protect a model and still be able to run it in External mode on these releases? protected, external, mode MATLAB Answers — New Questions
Can i use protected models in external mode?
I want created a Simulink Library for my Arduino Hardware. I created a model reference block and then convert a protected this block using callback.
But I run on External Mode, get this error :
Protected models do not work in External mode or rapid accelerator simulations.
Is there any solution method for this problem ?I want created a Simulink Library for my Arduino Hardware. I created a model reference block and then convert a protected this block using callback.
But I run on External Mode, get this error :
Protected models do not work in External mode or rapid accelerator simulations.
Is there any solution method for this problem ? I want created a Simulink Library for my Arduino Hardware. I created a model reference block and then convert a protected this block using callback.
But I run on External Mode, get this error :
Protected models do not work in External mode or rapid accelerator simulations.
Is there any solution method for this problem ? protected block, block, referenced model MATLAB Answers — New Questions
Date Return From Calendar
Hello everyone: new here Thanks in advance
Goal: I need to return the latest date a manager co-travelled with a Sales Rep.
I created a basic calendar, stating in Cell A3 I put all calendar dates running down column A. I then have 13 reps starting in cell B2 – N2 (running across row 2). All of the cells within are drop down menus containing the names of the same 5 managers.
I need to know when the last time a manager co-travelled with a Sales Rep. Knowing that a manager can co-travel with a single rep more then one time through out the year.
Thoughts?
Thanks
Steve
Hello everyone: new here Thanks in advance Goal: I need to return the latest date a manager co-travelled with a Sales Rep. I created a basic calendar, stating in Cell A3 I put all calendar dates running down column A. I then have 13 reps starting in cell B2 – N2 (running across row 2). All of the cells within are drop down menus containing the names of the same 5 managers. I need to know when the last time a manager co-travelled with a Sales Rep. Knowing that a manager can co-travel with a single rep more then one time through out the year. Thoughts? ThanksSteve Read More
Sort feature in Grid View
Hi,
Does someone know how I can submit a request to the developers? I’d like to request for grid view to have a sort option for all fields.
Thanks!
Hi, Does someone know how I can submit a request to the developers? I’d like to request for grid view to have a sort option for all fields. Thanks! Read More
