Forum Widgets
Latest Discussions
Look Up FX Rate by Transaction date
Hello Folks, Attached you will find a sample file where I am trying to do the following: https://docs.google.com/spreadsheets/d/1NeCSt8oAcEM86DAxI-8LkqTQK4D6WQvv/edit?usp=sharing&ouid=103354753371375324640&rtpof=true&sd=true Under the Data tab, if B2="C", then C2/xlookup(A2/FX Rate Oct 2025), C2) basically, if the Currency Code is C for Canadian then divide the Canadian $ on that transaction date by the reported FX Rate for that month that is stored in the FX rate tab. Otherwise, just return the contents of that cell. I tried to do a xlookup by the transaction date but since the data file is converted from a flat file template, I think my lookup function is not recognizing the lookup field between the array and the cell reference. I am more than happy to create a helper column for the Transaction date that will match the format of the month in the FX rate tab. Hope you can point out a clean solution for this approach. Thank you. Regards, Shams.
Rows being deleted unintentionally
Excel 2021: I have had severl instances when opening a particular workbook, or similar copies, of rows being deleted and the rest in a specific group of rows, being run together. I have 12 worksheets with months names on the workbook and this is happening on 11 of the sheets. I have to copy the good sheet, then select the other 11 and paste. It has been happehning many times this week.
Excel text box overlay- what is it, how to remove?
I have this box that has somehow been inserted into my table. There are underlying cells and I can actually scroll right under this box and also access the cell underneath it. And I can type about 140 characters into this box. Deleting surrounding rows or columns does not affect the box, so it doesn't appear to be correlated to a specific cell. There is no context sensitive help when in the box and almost all normal excel functions are greyed out when I'm in it. Any help is appreciated.Filter Function or any Logic
Dear Experts, I have a data like below , Column "H" has rnti's , Column "F" has sfn which can range from 0~1023( and once 1023 it shall start again from 0) slots that can range from 0~9, each sfn(say 252) has slots(0~9), Column "J" is Sn( Sequence number) , In Output , I want like this, example for the rnti 384, column "B" = count of spdu-1 for the rnti=384, and so on How the spdu-1 counted? (spdu-x's are counted per rnti & per-rlcCtrlAckSn_ ,) as below for example for rnti==384, Thanks in Advance, I posted this earlier also , not sure why post got deleted somehowCreating Formulas but not responding as expected.. Due to format of cell?
I have a large moderately complex workbook for forecasting / projecting a financial situation for next 30 years. It references data on multiple sheets. I'm using Accounting format, but I have removed / shifted the decimal places so it shows Custom for the format. It has been working fine, but yesterday when I attempted some changes, all of a sudden when I create a formula, even something as simple as =H36 or as simple IF statement, the cell remains empty or shows 0! I just tried something in some unused cells, where I did a simple =E31, which contains the value 12%. Three of the four cells show 12% the other $ 0. The three that show 12% were probably General to start, but now show percentage. The one that didn't show 12%, was Custom, from me using it previously to test thigs. I then formatted a blank cell Accounting and shifted decimals (sand it reacts the same way, and show $ 0, not 12%. What is going on? LOL E31 is manually entered 12% I entered =E31 in each of these cells below. (It won't let me use a table here...) They started as General. The one that doesn't show 12% was preformatted Accounting but with decimals shifted, so it shows Custom. The last one I formatted as Accounting without removing / shifting the decimals and it pulled in the 12%... I'm lost. What's gone whacky with the Custom format after shifting the decimals? It has been working fine. Thanks 12% 12% $ 0 12% 12% 12%Pictures inserted in cells disappear after closing and reopening a workbook
Windows 11 Home, 23H2, 22631.4317 MS Office L T S C Professional Plus 2024, version 2408, Build 17932.20130 Example: After saving, closing and reopening workbook, this is the result: I have tried all of the generic troubleshooting, because I have seen multiple people experiencing this issue - none of them work. 1. Display options for workbook are all checked (for object, show all) 2. Pictures are embedded, not linked to locally stored files - otherwise I wouldn't be able to retain them in online platforms (e.g. opening in Excel from Android, once storing in One-drive). Even if they were linked somehow, original files were never moved. When I upload the very same workbook in One-drive and open through any online platform (via browser - Excel Online, on Android - Excel app / Office 365 app) pictures are showing as intended. Problem occurs only on desktop app. I have already tried to reinstall MS Office, clean install, all updates - problem persists. I do not want any workaround solutions like: - using VBA scripts, - or inserting pictures over cells. as this is a proper bug and shouldn't require advanced skills from casual users. Inserting pictures over cells and embedding them manually - change size to fit into cell, set Move and size with cells is just partial solution - pictures will stay after closing and reopening, but you cannot refer to them properly - e.g. I want to have a result of X LOOKUP to be a cell with Picture inserted into cell (doesn't return a picture in cell if picture is placed above cell - doesn't matter if it is set to Move and size with cells. X LOOKUP with pictures inserted in cells works perfectly until I close and reopen locally on desktop app ( #UNKNOWN! everywhere), but continues to work perfectly in before-mentioned "online" platforms - though I am a bit more advanced user and lot of stuff I do can only be done in desktop app - as soon as I want to make some more advanced actions, I need to go back to desktop and all I get is a bunch of #UNKNOWN! where Pictures inserted into cells are supposed to be. Please solve this bug - it is very frustrating - I have lost straight 12 hours of my life trying to solve it, but I am at my wit's end. Thank you very much for reply.
CANNOT OPEN THE SPECIFIED FILE with tel:-hyperlink
Hi, I have several "tel:" hyperlinks in a Excel sheet (xlsm). Yesterday, they sended the phone numbers to whatsapp. But today i become the errer:"CANNOT OPEN THE SPECIFIED FILE". I saved yesterday a xlsx file as xlsm, after the conversion, the links were still working. What goes wrong?
Data Reconciliation Assistance Needed – Time Range & Sum Matching
I have two sets of data that need to be reconciled. Specifically, I’m trying to identify which combinations of numbers from these datasets can sum up to a specific target value. Additionally, the reconciliation should only consider entries that fall within a defined time range—from approximately 8:00 AM on one day to 10:00 PM the following day. I’ve tried using Solver and Goal Seek, but the results don’t seem accurate. I also attempted using Microsoft Copilot, but the outcome still appears incorrect. Could you assist with identifying or generating the correct combinations based on the criteria above?
