About 1,824,933 results (3,948 milliseconds)
How can I copy data from one sheet to another using IF statements ...
https://support.google.com/docs/thread/109233301/how-can-i-copy-data-from-one-sheet-to-another-using-if-statements?hl=en May 9, 2021 ... I'd like to separate the data out into multiple sheets so that different individuals can have access to only what they need to see. All data ...
Return sheetnames from multiple sheets if meets criteria - Google ...
https://support.google.com/docs/thread/107538347/return-sheetnames-from-multiple-sheets-if-meets-criteria?hl=en Apr 25, 2021 ... I have a master sheet that controls a dynamic amount of tabs. I am trying to search a column in each tab that match a cell and return the sheet name.
VBA Code; need linked cells to change color if condition met
https://groups.google.com/g/microsoft.public.excel.worksheet.functions/c/gIs8xRoweBE Aug 31, 2007 ... approximately 15 plus conditions. Streamlined Example Follows: In the workbook I have two (2) worksheets named: English & Math (I will be adding ...
Conditional Formatting: Highlight next blank cell in column if ...
https://support.google.com/docs/thread/53745172/conditional-formatting-highlight-next-blank-cell-in-column-if-statement-is-true?hl=en Jun 15, 2020 ... will highlight the next blank cell for me, but I'm not sure how to combine that with an IF statement so that it will be based off of what is ...
vba - Run-time error '13': type mismatch when using if statement ...
http://feedproxy.google.com/~r/stackoverflow/JqJq/~3/pl8pr63C6ZA/run-time-error-13-type-mismatch-when-using-if-statement Jul 13, 2021 ... I'd avoid using the square bracket notation, and you need to modify your check before you'd get the correct results: If ['Lab UP no 360 Chem ...
Question about speed and performance
https://groups.google.com/g/exceldna/c/9cJozLY1WWg Apr 17, 2014 ... NET-based add-ins with Excel-DNA and VBA macros depend a lot on what you're doing. If you're using the COM Automation interfaces to interact ...
I'm getting #ref when deleting rows. Is there a way to avoid this ...
https://support.google.com/docs/thread/84417645/i-m-getting-ref-when-deleting-rows-is-there-a-way-to-avoid-this?hl=en Nov 21, 2020 ... If my Manager deletes a row on the schedule tab, it causes a #ref error on the formulas & calculations tab. I'm not too familiar with excel or ...
Set up conditional formatting that is also case sensitive - Google ...
https://support.google.com/docs/thread/225325361/set-up-conditional-formatting-that-is-also-case-sensitive?hl=en Jul 13, 2023 ... Hi there, I'm new to googlesheets and excel, been trying to teach myself with this project. Sorry if I explain the below poorly: I have a ...
looping through inbox messages / debugger under Outlook VBA
https://groups.google.com/g/microsoft.public.office.developer.outlook.vba/c/9p2_guowWDA to in Access, Excel and Project. If I set a breakpoint, the code does not break. Stop statements don't work either. Sometime a MsgBox statement will pop a ...
Values in cell populating another cell if checkbox is true or false ...
https://support.google.com/docs/thread/98769069/values-in-cell-populating-another-cell-if-checkbox-is-true-or-false?hl=en Feb 18, 2021 ... It's the one I previously posted but it needed arrayformula added to make it work. =ArrayFormula(sum((D14:D21 * (1+H14:H21) * G14:G21) * I14: ...
PyDev of the Week: Chris Moffitt - Mouse Vs Python
http://feedproxy.google.com/~r/TheMouseVsThePython/~3/-r6CoNxPxSs/ Mar 7, 2016 ... If someone can write a complex if statement in Excel, then I am confident they can learn python. Which Python libraries are your favorite ...
replicating excel's textjoin with an IF function - Google Docs Editors ...
https://support.google.com/docs/thread/201897402/replicating-excel-s-textjoin-with-an-if-function?hl=en Feb 14, 2023 ... replicating excel's textjoin with an IF function. in excel, I have a chapter column and an adjoining location column. The formula <= ...
Charts in a mail merge doc
https://groups.google.com/g/microsoft.public.word.mailmerge.fields/c/j6uOG3vlRlQ I am creating personalized statement and want to insert a chart. I have set the statements up as a mail merge form letter mailing using an excel spreadsheet ...
Conditional formatting to highlight date within 14 days of today ...
https://support.google.com/docs/thread/35539865/conditional-formatting-to-highlight-date-within-14-days-of-today?hl=en Mar 25, 2020 ... I'm trying to apply conditional formatting to a column that has a date in it for "Rate Lock Expiration" (Column H). I want that date to be highlighted when it ...
IF statement can't return a NAMED RANGE
https://groups.google.com/g/microsoft.public.excel.worksheet.functions/c/i2exIaNGbMw I have an IF statement that returns the values within a multi-column/multi-row named range if true. The way that the statement is written, I'm getting a #VALUE ...
Can I AutoSize (or Fit) merged, variable data within a text box? H
https://groups.google.com/g/microsoft.public.word.mailmerge.fields/c/G3EuwX90ZAc Apr 25, 2006 ... multiple Access queries. Since this is a custom billing program for ... Unfortunately, I am not using IF statements for the messages as ...
Set conditional formatting to use a checkbox to change row color ...
https://support.google.com/docs/thread/189010230/set-conditional-formatting-to-use-a-checkbox-to-change-row-color-individually-throughout-the-sheet?hl=en Nov 17, 2022 ... I am attempting to set up a sheet that utilizes check boxes so that it will allow me to hit a check box and change that rows color individually.
Combining PDF
https://groups.google.com/g/adobe.acrobat.windows/c/Uk58405tIqs I am trying to combine PDF files generated by MS Access via Distiller, need to combine the separate pages into a single report but via a Access VBA program not ...
Re: [wxPython-users] wxPython & COM server
https://groups.google.com/g/wxpython-users/c/wumHB0CzvY8 I hope this answers your question and gives you a way to determine the parameters for other Excel statements. ... If you have query statements in MS Access with a ...
Code to move entire row to another tab based on cell value using ...
https://support.google.com/docs/thread/118114921/code-to-move-entire-row-to-another-tab-based-on-cell-value-using-google-sheets?hl=en Jul 22, 2021 ... If I run it on another sheet, it works perfectly fine. Any recommendations? function onEdit(event) {. var ss = SpreadsheetApp.