IF statement - Empty cell to be blank
Hi, I'm fairly basic with my excel knowledge. I have the below formula and table. The break column is a drop down box with selected times, I want the lunch column to return either a time of 12:15 or 13:15 depending on the selected break. A break time of 10 past the hour will have a lunch at 12:15 and a break time of 11 past the hour will have a lunch at 13:15. This formula kind of works however, I would like any unselected breaks (Cell B4) to be blank in the lunch column. I have tried "IFBlANK" and possible not using this correctly as I am continuously getting error messages. Any suggestions welcome. Thanks.
Excel for Mac - Run-time error '1004': Method 'Name' of object 'Addin' failed
Dears, Whenever I open any Excel File (existing or blank), I get the following error message: "Visual Basic for Applications Run-time error '1004': Method 'Name' of object 'Addin' failed" Note: I don't have any VBA code in the file - again, this message also appears when opening a blank/new/empty file. I thought it could be related to one of the Add-ins that I had installed, but even after removing all of them, the message still appears. Does anybody know what it means and how to fix it? I'm running Excel for MacVersion 16.91 (24111020) from Microsoft 365 in macOS SequoiaVersion 15.1.1. Thanks in advance, Andre
Automating Party Transactions in Excel Using VLOOKUP and VBA Macros or anything
Hi everyone, I have a main sheet named "DAILY INWARD OUTWARD" that contains transactions for over 50 parties. Each party does multiple transactions, and I need to manage their stocks. Currently, I manually create separate sheets for each party and record their transactions, which is time-consuming. See this is my master sheet and I make stocks like this That month Jodhka made 4 transactions, so by searching in master sheet all over made manually my diff party list. likewise i have to maintain 100+ party details, so anyone can help me reagarding this? I would like to automate this process using VLOOKUP and VBA macros or anything. Specifically, I need help with: Using VLOOKUP to fetch transactions from the main sheet to individual party sheets. Writing a VBA macro to create separate sheets for each party and copy their transactions from the main sheet. Any guidance or examples on how to achieve this would be greatly appreciated. Thank you!
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!Help with cross-cecking text values in a matrix
Hi There! i'd immensely appreciate some help from experts out there as i'm getting crazy trying working on a thing with my MacOS Excel I have the following matrix: I’m trying to create a formula to fetch the "TalentProfile" cell texts (High, Some, At) and cross-check them against the "Performance" text values (NotMeet, Meet, Outstanding) The central part of the table above shows what the cross-check should return: As example of the workflow behind it, there you go: If the TalentProfile text is "High" AND the Performance text is "Outstanding", then the text to be included in the result cell should be "TopTalent" if the TalentProfile is High AND the Performance is NotMeet, then the text to be included in the result cell should be "PotentialTalent" If the TalentProfile is "Some" AND the Performance is "Meet", then the text to be included in the result cell should be "KeyTalent" Etc..etc.....going so on fetching all the "Talent Profile" values and cross-checking with each "Performance" value, filling in the matrix or another table at choice I’ve already found a couple of tutorials here, making use of INDEX and MATCH but for some reasons they didn’t work on my make as it stopped processing the formula immediately as I entered it Hope you can spend some of your valuable time to help me on that Thanks!
Numeric range conversion
As part of survey data, I have an Excel column that is a numeric range for the time each respondent commutes (in minutes): 1-5, 6-10, 11-15, 16-20, 21-25, etc. up to 85-90, 90+. This was a mistake as I ended up needing a single number in order to calculate correlations. Does anyone have a formula for converting a numeric range to a single digit average? Such as 16-20 being converted to 18 and so on? Thank you!!!Trying to use equation In excel but keep receiving false message
Hi all, I am trying to submit=AI29=AJ29 into excel and it gave me a false message. I then tried to submit =IF(AI29=AJ29,TRUE,"") and it completely deletes the message. Im not sure what else to do. Im trying to use the y=mx+b equation from the graph in excel, to plug the y values back into x to solve for x, in order to check for continuity. If you could help, I would appreciate it!Pivot Tables in Word for Mac
My very complex investment spreadsheet, which used lots of pivot tables, no longer works and the file is said to be corrupted and won't open. In terms of design I have a master table (showing entries for stock purchases) from which the pivot tables take and show the data. The master table has about 30 columns, and around 3500 entries to date (I buy little and often). It uses lots of formulas, including things like Stockhistory. So it is a pretty complex table, but up until now I've had no real problems and it only takes a few seconds to refresh the data. I've tried restoring previous versions but that doesn't work. So I started a new spreadsheet. I put just 10 lines of data into my master table and set up a couple of pivot tables (writing things from new, rather than copying directly from the old spreadsheet). Excel was unable even to handle that. After I saved the document and reopened it I got an error message. It was able to open the document, but the data in the pivot table was fixed/static and the pivot table element itself had been removed. Has some update to excel for Mac completely screwed pivot tables? Or what else might explain this? Thanks in advance.
