User Profile
Ezio-de-Pazzi
Brass Contributor
Joined Oct 02, 2022
User Widgets
Recent Discussions
Re: Excel marco has been blocked when I'm using the excel in Onedrive!!
SangNguyen That's weird. Cause from what I've heard, it's supposed to be fixed by adding the onedrive path to trusted location. According to the articles below: https://support.microsoft.com/en-us/topic/a-potentially-dangerous-macro-has-been-blocked-0952faa0-37e7-4316-b61d-5b5ed6024216 https://learn.microsoft.com/en-us/deployoffice/security/internet-macros-blocked#block-macros-from-running-in-office-files-from-the-internet https://learn.microsoft.com/en-us/deployoffice/security/trusted-locations Office will 1st check the file whether it in the trusted location or not, then decided to proceed the procedure or just full green. I suggest you manually remove the MotW (Mark of the Web) just for a test. If it runs normally, then it must be some mistake about your Trusted Location or Trusted Centre. Please double check them. If the issue stills, perhaps you need to check the Office program file integrity because it should be fine by design.Re: excel how to display table with list of members
bbsin There is no need to manually set every filter function. Since there are relative references to table number, you could easily complete every table sheet by just copy and paste it. And you don't have to reference one column in every filter function. Below should be better. =FILTER(List[[Guest Name]:[Catoegry]],List[Table '#]=I9)Re: excel how to display table with list of members
bbsin please check this if I got your point. Cause like L z. said it really confused me for a long time. It's pretty easy with the FILTER function. =INDEX(FILTER($A$3:$C$26,$C$3:$C$26=F3),SEQUENCE(ROWS(FILTER($A$3:$C$26, $C$3:$C$26=F3))),{3,1}) I strongly recommend you to use Excel Table to structurize data, this way it could automatically resize the data range if you add. Plus, the function would be more understandable. =INDEX(FILTER(List[[Table '#]:[Guest Name]],List[Guest Name]=F3),SEQUENCE(ROWS(FILTER(List[[Table '#]:[Guest Name]],List[Guest Name]=F3))),{3,1})Re: Excel formulas
A B C 1 test4 four orange 2 test5 five white 3 test8 eight green 4 test7 seven orange 5 test9 nine silver 6 car ten black 7 test6 six green 8 test2 two green 9 test3 three orange 10 test1 one green If the data preset is like above, than your target function will be : =XLOOKUP($I$3&$J$3,$C$2:$C$11&$D$2:$D$11,$B$2:$B$11,"NA",0) Una_McCrossanRe: zip code
Samon1900 It suppose to. Because excel trying to identify your zip code as a numerical data. Thus, any 0 in prefix would be meaningless, so excel clear it automatically. Solution is very simple. Just change your cell format to Text. This way excel would identify your zip code as a string data.
