Recent Discussions
vlookup issue
Hi Expertise, I have a problem regarding to vlookup issue. I need to use the staff ID prefix which is the first 3 characters (numeric or alphanumeric) of staff ID to lookup the team. I tried to use vlookup or Index and Match or xlookup, unfortunately, still have error. May i ask your help? Thanks I tried to use left(staff ID,3) or value(left(staff ID,3) to capture staff id prefix. Staff ID Staff ID prefix Team Staff ID prefix Team 736123 736 HK 736 HK 736124 736 HK 73A JP 73A123 73A JP 73B KR 73B123 73B KRSolved47Views0likes1CommentMarkup Panel appearing with every word document. Comments column now in some weird thing.
Good day, I am so confused I do not even know how to explain all the issues. 1) Opened a word document today that I closed yesterday. Opens up with some thing called a Markup Panel. Go to review and select no markup. Fine for now, but then appears every time I reopen the document, and all other documents. 2) Up until today, my comments were nicely formatted in a column on the right side of the screen. Now they are in some thing called a "reviewing panel" which is terribly formatted and located in the wrong place until I drag to to the right side. Is this something I have caused or some Word Update (God, I hope it is not the latter.) 3) Also, the little indicators next to the lines where the comments are located are no longer present, so the only way I know there is a comment on that line is by clicking on the comment in the stupid "reviewing panel" How do I get back to what I had yesterday? Thanks so much for your help. DaveSolved48Views0likes1CommentToggle Button Code
Hi I have the below code in a toggle button which places an ‘X’ in the active cell which could be anywhere on the spreadsheet. Private Sub ToggleButton1_Click() If ActiveCell.Value = "X" Then ActiveCell.Value = "" Else ActiveCell.Value = "X" End If End Sub Is there a change to the code I can make to force the toggle button to place/remove the ‘X’ from specifically cell ‘C3’? Many Thanks AndySolved50Views0likes2CommentsVisible Margins
As a heavy user of Publisher I am learning my way through Word in view of the upcoming cancelation of Publisher. One of the first things to strike me is the inability to make margins visible. Anyone found a way? I have tried text boundaries but it does not really help. I know Word is not a graphics package but I do not see much else within Office 365. A pity there is not another MS product to fill the gap! Or is there?Solved64Views0likes3CommentsApplication.SaveAsText posible Bug
I'm discovering the powerful Application.SaveAsText and LoadFromText methods, never used before, and found that Application.SaveAsText acTable,... always produces an Error 2.487: The Object Type argument for the action or method is blank or invalid The method works flawlessly with any other ObjectType. I've tested this behavior in a bare new accdb, with a single table in it, in three different systems (win10 & win11), all yielding the same result. My Access is 365 2508 (32 Bits) May someone check if it is a bug?Solved92Views0likes3CommentsDelete Empty Rows ONLY
I saw someone else's post, but nobody addressed the problem. Their solutions delete every row that contains a blank cell. I want to delete ONLY the rows that are COMPLETELY blank. The top rows are what I want it to resemble. The bottom several green blank rows are what I want to batch Delete.Solved82Views0likes3CommentsExcel help!
How would I capture the data from the last cell in a column when the column length is variable?Solved234Views0likes15CommentsHaving trouble with IF formula
Hello, I'm not sure what's going on with my formula, but it is supposed to double the "Grip" when a checkbox is checked. All the numbers being pulled from tables are correct and when not checked the "Grip" adds up correctly. When doubled, it is also adding the "Wall Thk." number an extra time. Correct single Grip = 1.625" Correct double Grip = 3.25" I get 3.5" for double grip. Formula used below, as well as pictures. If my formula is wrong, then I can't see it, but it has to be adding T8 somehow. =IF(X8,((INDEX(DATA_THK,MATCH(1,(Flg_Thk[Spec.]=N8)*(Flg_Thk[Series]=O8)*(Flg_Thk[Class]=P8)*(Size=Q8),0),MATCH(R8,FLG_TYPE,0))+T8*(R8="Lap Joint (LJ)")+V8*(U8="RF"))*2),(INDEX(DATA_THK,MATCH(1,(Flg_Thk[Spec.]=N8)*(Flg_Thk[Series]=O8)*(Flg_Thk[Class]=P8)*(Size=Q8),0),MATCH(R8,FLG_TYPE, 0))))+T8*(R8="Lap Joint (LJ)")+V8*(U8="RF")Solved89Views0likes5CommentsFilter function with a criteria
Dear Experts, I have a data like below( in columns A/B/C) , and needed the result in column (I/J/K), but I could achieve only like in Column (E/F/G) For example for the rnti = 19453, the corr0 , at time -> 06:34:32.171912 is not there so at Row-3, the entry should be empty Attached is the worksheet, Br, AnupamSolved135Views0likes4CommentsHelp with formula
Hello! If I'm trying create a formula that pulls data from one sheet into another. I want it to pull in data in column E if column B has a january date AND column C has the word discover in it, into another tab within the same workbook. The formula below works perfect but the only problem is it has to be only the word "discover" (yellow cells) in the cell, if it says "discover - food" (green cells) it doesn't pull. Is there a way to have the formula pull the data if the word "discover" shows in column C but with other words like in the green cells? My current formula that kinda works: =INDEX('My ✓ing'!E:E,MATCH(1,(MONTH('My ✓ing'!B:B)=1)*('My ✓ing'!C:C="Discover"),0)) Pulling from this sheet below Into this sheet in the same workbook. The yellow ones work because it just has discover, the green is not cause it has Discover - food. Is there a way to get it to search for the word discover and not necessarily match? Thank you for any help!Solved135Views0likes5CommentsTotalling money in categories and sub-categories across multiple columns
Hi Community I am trying to wrangle a large income dataset for an organisation in Australia. I have a large spreadsheet that has multiple text categories whose value is tied to a $ amount. Not all Projects receive every category of funding, so some blanks exist. The categories are treated as text. So for this example, I need to be able to get the total Funding $ amount for Research Category 10, across Category 1, 2, and 3. I have hundreds of rows set up like this: How do I get the total funding amount of each research category in my table? I have literally hundreds of rows set up like this. Project Name Research Category 1 $ allocated to Cat 1 Funding Category 2 $ allocated to Cat 2 Funding Category 3 $ allocated to Cat 3 Cat research 10 $4000 15 $100 Dog research 20 $50000 22 $3000 10 $5000 Car research 25 $9000 30 $80000 22 $1000 Table research 30 $1500 10 $1500000 Food research 10 $150000 20 $4861 15 $3000 Engineering research 15 $6000 10 $5000 Flag research 25 $5600 30 $8000 15 $800 Dust research 20 $99665 15 $130Solved87Views0likes4CommentsError installing Apps 365, command not supported.
I was performing an Online Repair for a user. It did the uninstall fine, but then threw this error. I tried to reinstall, same error. Used the MS Cleanup tool, ran SFC, cleared temp files, cache... Internet connection is stable. Disabled security software (Zscaler). I'm out of ideas. I'm hoping someone has seen this before. Thanks for any help!Solved85Views0likes2CommentsUsing sortby and filter with a named range
Howdy. I have the following formula and it works fine. =FILTER(tblBasketList,(tblBasketList[Crew]="Days")*(tblBasketList[Last]<>"")*(tblBasketList[NoLight]<>"x")) The main "tblBasketList" is sorted first by Crew, then Unit, then Basket number. I want to do a sort where two different values in the crew column are combined, then sorted in a specific order. I'm able to get filter to show the two together. I'm just having trouble figuring out how to apply Sortby to it. =FILTER(tblBasketList, (tblBasketList[Last] <>"") * ((tblBasketList[Crew]= "A") + (tblBasketList[Crew] = "Days")) * (tblBasketList[NoLight]<>"x")) I've tried referencing the tblBasketList columns by name. I've tried doing it by column index. Neither worked, and I'm fairly certain it's just me messing something up. I want to sort it by a column named Unit, and then by BasketNumber. Which are the 5th and 1st columns. Any advice would be appreciated.Solved62Views0likes2CommentsData Masking Emails using Formulae
Hi guys, I am trying to work on my data masking skills and have ran into a problem. I am trying to mask the email addresses of the following data set (this is a fake set of data from an online course btw). I want to mask the emails such that: email address removed for privacy reasons will then become b******email address removed for privacy reasons . I want to make sure that the number of Asterisks represents the number of characters displaced, I have spent a while trying different formulae, however I have been able to generate a formula for the first email from E2 into F2, although this doesn't seem to work for the other rows of emails. Any help is much appreciated :)#Solved94Views0likes3CommentsVlookup returning random #NAs, Randcom Correct Responses
I have a multi-sheet workbook, with a named array of data. On a separate sheet I cite a first-column text of that named array, to extract datum from a column on that specific row. In other words, "VLookup." Maddeningly, there are some instances where the use of one of the text-strings in the array, produces an "NA" error. I can't figure this out, because I have: --Checked to make sure the named array covers the fields to which the Vlookup refers. --Checked (using "EXACT," "Cell=Cell," even simply copying the value from the named array into the formula) to make sure there are no common text/formating/other discrepancies between the citation and the cited cell. --Checked (redundantly) to make sure the cited cell DOES exist in the array. --Tried with other citations (some of which always work, some of which always do not. I will post/attach the file. Please note, the workbook is being developed, and so it's somewhat disorganized, but the two pertinent worksheets are "1 GenReservation Data" & "2 AvailabilityCalendar" The cell in question is in the "2 Availability Calendar", C17. This cell uses the results of B17 as the "Lookup Value" in the array titled "AE01_ReservationInfo." While there might be some thing caused by the formula in B17, it doesn't seem so: As you can see by some attempts by me to figure out the error, I've created a simple stripped-down Vlookup formula to resolve the problem, and the same thing happens, even if I simply copy from the Array the text that Vlookup must look up. I've also used other citations from the "1 GenReservation Data" page both directly and in the formula and they often work. For example, using, (either directly or derived via formula) the text "Farquar 2026-0415" or "Johnsonite 2025-0115" never work. But all the others do. Thanks for your ideas on this one! Sorry, this is my first posting, and I cannot see how to attach the file. Assumed that would be obvious (and maybe it is, but not to me :( ) So if you can help with that issue, I'll be able to provide a better context. But I'll try to include a table to illustrate the issue, even though that will only show . ...and that didn't work either. Claimed my table had invalid HTML and told me to remove tags...which I don't know how to do. Thanks for your help, either way.Solved59Views0likes2Comments
Events
Recent Blogs
- New Outlook for Windows has top-requested capabilities like pin important emails, add shared mailboxes as accounts, and newsletters.Sep 16, 2025491Views0likes1Comment
- Customize your OneNote pages on Windows by deciding whether the Copilot icon appears.Sep 12, 2025481Views1like0Comments