Forum Widgets
Latest Discussions
IFS or anyother function
Dear Experts, I have a data like below:- So, Column "B" - sfn can go from 0 ~ 1023, and Column-"C", can go from 0~19, Column "G" has 3 values(rnti's) - Now, we have only 2 situations like below in Column"E", where I need the formula:- Either all these 3 rnti's can be Multiplexed in the same sfn.slot So, in below snip all 3 rnti's are FDMed in same sfn.slot - 394.6 and should be continuous, so Column "E" should have fdm-3 But in below instance, in 395.2 we have only 2 rnti's multiplexed(so fdm-2 should be populated) Attached is the spreadsheet. Thanks in Advance, Br, Anupam
Adding COUNTIF formula to cell by VBA code
Morning all, need some assistance. Attempting to insert a new formula by VBA with an already working Macro. All the other references unhighlighted below work perfectly, but I am missing something with the syntax around a countif function. The countif currently works on the excel sheet itself, however adding it into the VBA is generating the typical "Compile error: expected: end of statement" error indicating a syntax problem. Any advice?
underline in cells not present after leaving cell
I am trying to insert a header on a page and in the left header cell, insert text and underline. The text and underline can be inserted and is displayed when the cell is highlighted, but when I leave the cell the text remains, but the underline disappears. Printing the document the text is printed, but the underline is not. The underline is intended to be a "marked" space to write in text on the printed document. I've tried different methods to apply the underline, but the same issue occurs. Any suggestions?'apostrophes
new problem only on this computer. using excel now my spreadsheets are useless as they now have an apostrophe added to the beginning of each cell eg 'Alec '8482 '1=3 is there a button I need to unclick or something??? it has to be on this computer as I sent an unaffected workbook from another computer but it read the same once opened on this computer. hence this computer must have something activated to put ' on every cell. does anyone have any solutions to this please?Keep a number as "General"?
How do we keep a column of numbers as type General? For example, I have column L. I highlight column L. I set type of the entire column L to General. I go into several cells in column L and confirm that they are type General as I had set them to be. So I enter a general number into my cell that I set as a general cell. Excel decides that, no, what I really really want is for that cell to be set to Accounting which means that the cell displays ###### unless I widen it, at which point it becomes a dollar figure. But I'm not dealing with dollars. I'm dealing with general. Which is what I had set the column to be. So I have to go back EVERY TIME I enter data into a cell and switch it back to General which is what I already set it to in the first place. This would make some sense if I had entered 1/17/2025 and it decided to change what I told it (General) to a date, even though I had already told it that I want it to be general and therefore display the '1/17/2025' that I had entered. But if I enter '10230' into a cell that I had specified needed to be General, Excel should not decide that I wanted it to be $10,230.00. I did not. How do we prevent Excel from overriding our settings?
