User Profile
nicoleahmed
Brass Contributor
Joined Jan 10, 2023
User Widgets
Recent Discussions
Re: What is the URI scheme in order to open MS Teams from another APP (deep link) ?
JS_NKD To link to the chat of a channel you can right click your channel in teams and select get link to channel. Then replace https with msteams. You'll get something like this msteams://teams.microsoft.com/l/channel/<channelid>/<channelName>?groupId=<groupid>&tenantId=<tenantid>13KViews1like3CommentsRe: Create Searchable Drop Down List for Table With Multiple Rows
This is brilliant thank you! I didn't use the VBA code to sort a-z, i just used the table sort function. My range formula: AllSites: =OFFSET(AllSites!$B$2,,,COUNTA(AllSites!$B:$B)-1) My data validation formula: =OFFSET(AllSites!$B$2,MATCH($B9&"*",AllSites,0)-1,,COUNTIF(AllSites,$B9&"*"),)3.7KViews0likes0CommentsRe: Excel Searchable Lists
This looks great thanks. From what I can see, the data validation formula would need to be changed for each cell making this a bit time consuming for bigger sheets needing lots of choices - but I can see this being very useful for some purposes. the data validation formulae in F2 and F3 were * =IF((F1<>"")*(F2="")*(F3=""),StdMales,IF((F1<>"")*(F2<>"")*(F3=""),FtdMales,"")) *=IF((F2<>"")*(F3="")*(F4=""),StdMales,IF((F2<>"")*(F3<>"")*(F4=""),FtdMales,""))10KViews0likes1Comment
Recent Blog Articles
No content to show