Logical test for same text string existing anywhere in both ranges.
Hello. I have a Table of film credits, including the names of directors and writers. Some films have multiple directors (up to 3 individuals), whose names are in columns F, G and H. The writers' names (up to 4 individuals) are in columns J, K, L and M. I want to test for whether the film has a writer/director - e.g, one of the director names in the range F:H is the same as one of the writer names in the range J:M. I have created a column O to contain a formula with a logical test returning Y if there is a writer/director present. I tried =IF(Table4[@[Wri1]:[Wri4]]=[@Dir1]:[Dir3],Y,N) but this returns a spill error. Can anyone help?
Compare or search one data table in another table in Excel
Hi, We have two data tables in Excel that have a foreign key (a common field with the same data type). We want to search for the existence of data from the first table in the second table and identify if there are any inconsistencies in this comparison of the two tables. It should also display the found data separately. What method do you suggest? tnx
Excel cell calculation
Hi all, first timer here. In Mac Excel I’m wanting to calculate a selling price minus a cost price times the amount of items. So cell D4 is $3, minus cell C4 which is $1, multiplied by 18 items B4. In E4 I have done the formula of =D4-C4*B4 but I get -$15 which is incorrect, should be $36 Where am I going wrong? Thanks all
Excel Formula Help: Reflecting Dynamic Monthly Credit Card Payments by Date
The Goal: To display the correct monthly payment amount (from the Debt Schedule tab) on the Main Worksheet tab, placing each payment under the correct date column (J4:AV4) based on the due date for each credit card. The Problem: The Debt Schedule tab lists multiple credit cards and a month-by-month payoff schedule. As each card is paid off (listed lowest balance to highest), its scheduled payment rolls over and is added to the next card’s payment. However, the formula I’m currently using on the Main Worksheet tab does not capture these changing payment amounts over time. I need a formula or approach that dynamically reflects the evolving monthly payment amounts as cards are paid off. Google Drive Link: https://docs.google.com/spreadsheets/d/1jPYLWfuOxEtxF3Mvfo5PFUTsE3_x_5iH/edit?usp=share_link&ouid=102575009763592887799&rtpof=true&sd=trueUsing Upper and or Proper Function - not working properly
I am trying to use the UPPER function on my Excel sheet. I was able to format my first column, but when I try the next column, it won't convert. I have tried several times, and it will not convert the function. I have included two screenshots to show the progression. I formatted the column to text, and have tried to troubleshoot any tips I have come across. I have tried both on my desktop and uploaded to my 365 and both have the same result. What am I missing?How to make excel add or remove rows to fit data and prevent spill error?
Hello! My question is: When using the =FILTER formula to copy cell data from one sheet to another, how can I make excel add or remove rows as needed to prevent a spill error? I am using the =FILTER formula to copy cell data from one sheet to another if a checkbox is checked. My formula uses the cells containing the checkbox (column A) as the reference for columns B, C, D, etc. to the right. I did this by selecting the cell that has the formula on the destination sheet, highlighting this cell and those to the right I wanted to transfer, and then control + r. My formula is: =FILTER('Source Sheet'!B5:B13,'Source Sheet'!$A5:$A13=TRUE) (If there is a way to copy an entire row from the source sheet instead of having to control+r to apply the original formula across select cells please also let me know, thank you!). However, I want the sheet to be able to automatically add rows to fit the data if the selected number of rows is greater than what I have left available on the sheet. Currently, if I leave 3 rows for data to fill and I select three checkboxes, this will fill the space with no problem. However, if I select 4+, I get a spill error (as there are not enough empty rows to put the data). Is there any easy way to have excel add rows as needed? Similarly, is there a way for excel to remove rows as needed? I am going to use this sheet to detail all medications being taken by family members (with medication name, concentration, dose, time to take each in their own column as column B, column C, column D, column E). The names will be listed in column A with ~3 rows below each name which will fill when the checkbox on the source sheet is clicked. I want to ideally fit this on one page when printing without major "fit to page" problems that come up during printing. The layout of the sheet will ideally look like this: The goal for the 'destination sheet' is to pull only the selected data I want to use from my master list on the 'source' sheet.' I want to avoid having a big empty space under each family member where they don't take many medications, and to also not have to manually add rows for family members that take a greater number of medications. Please let me know and thank you!
Excel banner goes grey in MacBook when screen is maximised
When I click green circle in top left/h corner to maximise screen in macbook, the excel green header turns grey and icons are dificult to see. if i then click yellow circle to part minimise screen, header goes back to green. I have done a short screen capture video to show this. Why is this happening, can it be fixed please? Tks, Jon.
