Profit/Loss per Day Calendar
Hi All, I am looking for formula for these 2 items. 1. Want total Profit/Loss per date in Calendar (E.g. Total Profit on 02 Feb 2022 was -90.65). 2. If Profit Cell to be Green, If Loss cell to be Red Link to Excel Sheet. https://1drv.ms/x/s!AlvQCyQGg78NgkNEsm2PYzAfJIEo?e=bF7ctc
Converting PDF to Excel 2024 on Mac (Not O365)
Hello Guys, Looking for advice on converting a PDF to Excel on my Mac. I'm using Excel 2024 and not Office 365. Most of the solutions I've come across online seem to cater to Office 365 users. I need to convert PDF content into Excel format so that I can work with the content. Does anyone have suggestions with a step by step approach how to do so. If there is any macro available or any step which doesn't involve the use of third party tool I'm fine. Appreciate your help!
How to restore the option to delete row in the edit drop down menu in Excel Checkbook 2023
I just downloaded excel checkbook 2023 and am setting up my register. Originally I had the option to delete row in the edit drop down menu, but then after deleting a column I now only have the option to delete columns. I want to restore the option to delete a row instead of deleting columns. How do I do that?Long data copied to wide data
Hi, I am trying to do exam analysis and need to copy data from Excel (see image) into my home-made analysis sheet on Numbers mac (see image). The trouble is the exam board data is in a long format data sheet while my numbers table is in a wide format. I have tried copy/paste special/transposing but all that does is run all the candidate names horizontally along with the data horizontally (see image). What I am looking to try and do is have the candidate names go down in a column and have the data from each question run horizontally across from their name. How can I do that? Any help would be immensely appreciated - I have been at this for 2 hours now and am sure I could have just single-copied all the data by this point!!!
Concat and Concatenate problem
I have 203 column of data that I need to merge each row of that data into one column - tyring to merge street names for a list of addresses. I ahve done this before but the function does not seem to be working. Can someone help? What I tried: =Concat(c2,d2:c39,d39) then =concat(c2," ",d2) this was just to join first row of info then tried the same function with concatenate.Excel (on Mac) Macro Highlight to the Top of a Column
Column F in the below table includes a blank cell. In a macro, I want to highlight cells F2 to F10. Since I could have any number of rows of data, I wrote the macro to get me to the last row of data, then highlight my way up using: Range(Selection, Selection.End(xlUp)).Select But since I could have any number of blanks in Column F, I had to repeat that line 12 times to be sure my highlighted range would always go to the top of the column. Is there a way to anchor the highlighting at the last row of data (as I have done), but then make E2 the "top" of my highlighted range?
Finding cell name given two inputs
Dear Sir, I have spread sheet like below. Frquency SIL 5 SIL3 SIL4 SILH SILH SILH 4 SIL2 SIL3 SIL4 SILH SILH 3 SIL1 SIL2 SIL3 SIL4 SILH 2 SIL0 SIL1 SIL2 SIL3 SIL4 1 SIL0 SIL0 SIL1 SIL2 SIL3 Consequence 1 2 3 4 5 Frequency 1 Consequence 3 SIL XXX I want to write formula in cell as shown as XXX, the formula should give me the result as SIL1, if i change Frequency and Consequency like say 2, 4 respetively then i should get SIL3. Please let me know what formulae or function i should use, roughly i know it is like INDEX and Match, i tried but INDEX take only column but my arry is in both column and rows like B2:E6. Regards.
