User Profile
K_Stuart
Copper Contributor
Joined 5 years ago
User Widgets
Recent Discussions
Re: Require assistance with the following formula/method to use the V look up tool (explained below)
https://exceloffthegrid.com/download/2663/ This can help you with advanced vlook up formulas - link will download a pdf cheat sheet that breaks down wildcards to multi part conditionals. -CHEERS, KS697Views0likes0CommentsRe: Require assistance with the following formula/method to use the V look up tool (explained below)
Hey - unless I'm not understanding you correctly this will work as expected; =VLOOKUP({cell with value I am checking for},{the data range with headers and labels to check in}, ,MATCH({second conditional to search by row for},{the range to apply the search with no headers or labels},0)+1,FALSE) It will preform what is called a two way look-up; you can achieve this with any number of lines or worksheets to make more complex conditionals, you can assign this to a LET variable function as well if needed in some but not all situations and apply IF AND NOT TRUE FALSE Logic from there - Hope this help, if unclear, look up "2-way look-up excel on google"702Views0likes1CommentRe: OneDrive on Linux
Example 'null' [do NOT use in production or other than general convenience] For DEV or Prodo use: Look below at 1 - 3.B.1 null: ============ Download Google Chrome Beta or Dev (keep the paths and SSH key separate- a tmp user account is my usual go to on fedora) In the browser - click you can mount it as a separate drive on your file system. No sudo required. muratkazanova end null ======== Adv Look: ======= Before that trick and one I still leverage for cloud computation and clusters: 1 Set up a desktop controller, ie. FTP, SQL, Kube, etc. <- you get it -> 2 SharePoint server - Hint SharePoint online works just fine 😃 3.A.0 - Set up a share file with some- python, or- json, or- java, or- etc. 3.A.1 To add security/api's (running a workflow to the 'www') 3.B.0 For local or dev: 'curl' is best practice - 3.B.1 SharePoint_CLI on github - Hint look for ms365 under the topic 'Microsoft' End Adv Look ======== Close: If your still out there in the wild working on this - I can dev a framework to fit the use case and tarball it for you but I would need to know the logic just so I could make it useful, mine is pretty "neat-o", I can snap up something fairly quick if needed Safe travels - KS1.1MViews0likes0Comments
Recent Blog Articles
No content to show