logo
down
shadow

EXCEL QUESTIONS

Excel if <> #NA
Excel if <> #NA
To fix the issue you can do To begin with I've tried searching the forum and can't find what I'm looking. , Check below formula:
TAG : excel
Date : November 28 2020, 11:01 PM , By : swati
Excel vba to remove "?" (question mark) and "*" (star)
Excel vba to remove "?" (question mark) and "*" (star)
I wish did fix the issue. Question marks and asterisks are known as wildcards in find and replace functions, this means they already mean something other than their string values. In order to get round this you need to precede them with a tilde (~).
TAG : excel
Date : November 28 2020, 11:01 PM , By : Manobala M
Use vba to write formula in cell
Use vba to write formula in cell
Hope that helps You just need to edit the 25 in For r = 2 To 25 to the last row you want to fill with the formula.Code:
TAG : excel
Date : November 27 2020, 11:01 PM , By : HoverKat
Writing IF statement for ODD numbers
Writing IF statement for ODD numbers
wish helps you Here's an array formula that will work but I think there is a simpler way. You'll need to press ctrl+shft+enter:
TAG : excel
Date : November 26 2020, 11:01 PM , By : venkat jangareddy
Trying to delete all Rows until Cell (A,1) has certain value
Trying to delete all Rows until Cell (A,1) has certain value
I wish this help you L.Dutch already gave you the answer to your questionhere's an alternative and faster approach
TAG : excel
Date : November 26 2020, 11:01 PM , By : Justin J Cruz
How to add round values in VBA?
How to add round values in VBA?
I wish this helpful for you I want to individually add values together, while simultaneously rounding the values. Suppose, after rounding 12.5 will be 13 and 18.75 will be 19. I want to add 13+18.75. The result should be 32. How can I do this in VBA?
TAG : excel
Date : November 25 2020, 11:01 PM , By : Anasrul Sholikhin
What does the second specified button in a MsgBox do?
What does the second specified button in a MsgBox do?
wish of those help The MsgBox command can be used to display a variety of different messages including (but not limited to) the following types: yes / no, ok, retry, etc.So, the MsgBox can be customized to some degree. In order to allow for that Micr
TAG : excel
Date : November 24 2020, 11:01 PM , By : Djsid
Error when pasting values using macro
Error when pasting values using macro
should help you out You overwrite the pasted values right in the next line with ActiveSheet.PasteAlso you should not use .Select and Selection..
TAG : excel
Date : November 24 2020, 11:01 PM , By : chandu chintu
How do I get count of visible rows after filter in Excel VBA
How do I get count of visible rows after filter in Excel VBA
should help you out your narrative is about "counting the visible rows" while your code shows a SUM() functionanyhow here's how you can get both numbers, keeping in mind that Autofilter() will always filter header row, i.e. the 1st row of the range i
TAG : excel
Date : November 23 2020, 11:01 PM , By : Sneh Choudhary
Excel SUMIF criteria within range of numbers
Excel SUMIF criteria within range of numbers
I think the issue was by ths following , I agree with @user3240704 that SUMIFS is the way to go.If you insist on using SUMIF only then you can use the following logic:
TAG : excel
Date : November 23 2020, 11:01 PM , By : sparky
Is there a way for a temp file Excel Add-on to know if it's public read-only file has been updated since the end user ha
Is there a way for a temp file Excel Add-on to know if it's public read-only file has been updated since the end user ha
hope this fix your issue I would add an extra worksheet to your add in and use ExecuteExcel4Macro to check for version updates.
TAG : excel
Date : November 21 2020, 11:01 PM , By : Jindřiška Zajicová
How to filter the correct line in sheet instead of IF-statement (Excel)
How to filter the correct line in sheet instead of IF-statement (Excel)
Hope that helps In my excel sheet i have the following function: , Complex Lookups in Excel Solution to your problem using SUMIFS
TAG : excel
Date : November 20 2020, 11:01 PM , By : Howard
Delete worksheet if it exists and create a new one
Delete worksheet if it exists and create a new one
I think the issue was by ths following , Remove the End statement, your code terminates after finding and deleting the worksheet asdf.
TAG : excel
Date : November 19 2020, 11:01 PM , By : tvp
How to find values in one column in another column with multiple values
How to find values in one column in another column with multiple values
around this issue I have an excel like , In E2 enter:
TAG : excel
Date : November 18 2020, 11:01 PM , By : Igor Achieser
Add values uniquely in Excel column
Add values uniquely in Excel column
may help you . No programming is required for this.Select cell A1 and apply Data Validation to it using the formula:
TAG : excel
Date : November 17 2020, 11:01 PM , By : Jessie O' Brien
Excel - Summary calculation
Excel - Summary calculation
should help you out Could someone please help me to figure out How to get the summary for every month from the grid in Excel? Please find the following image for the information. Thank you in advance. , You try with the below formula
TAG : excel
Date : November 16 2020, 11:00 PM , By : Terrance Bulluck
Excel: How to create (static) array constant {1,2,3,...,100}
Excel: How to create (static) array constant {1,2,3,...,100}
fixed the issue. Will look into that further Both OFFSET and INDIRECT are volatile. Since, in the following syntax, it is volatile "at workbook open only" (http://www.decisionmodels.com/calcsecretsi.htm), preferable is INDEX:ROW(INDEX(A:A,1):INDEX(A:
TAG : excel
Date : November 14 2020, 11:01 PM , By : Petr Dobrovodsky
MS Excel - How to refresh a cell automatically every 5 seconds?
MS Excel - How to refresh a cell automatically every 5 seconds?
around this issue I have a cell in my Excel sheet and I need this cell to be refreshed every 5 seconds. , Got it, now it works:
TAG : excel
Date : November 14 2020, 11:01 PM , By : Doe
Avoiding duplication of function prototypes using constants in VBA for Excel
Avoiding duplication of function prototypes using constants in VBA for Excel
it fixes the issue This isn't possible. VBA doesn't have a preprocessor in the traditional sense, despite appearances. Const declarations can be used only in If statements and cannot be substituted into actual code, while the Lib in a Declare stateme
TAG : excel
Date : November 13 2020, 11:01 PM , By : Dawid Kubić
Excel - Replace matching column values based on another column set
Excel - Replace matching column values based on another column set
fixed the issue. Will look into that further Have you tried vlookup? =VLOOKUP(C2,[Book2]Sheet1!$B$2:$C$8,2)Where [Book2] is where your correct or new ID's are.
TAG : excel
Date : November 12 2020, 11:01 PM , By : Patrick Carne
how to get different cell groups each add up to a certain number
how to get different cell groups each add up to a certain number
hope this fix your issue As I mentioned in the comment, the standard solver in Excel has a maximum limit for decision variables of 200.This example is limited to 200 variables - if you have the premium solver, you can expand the solution. This was do
TAG : excel
Date : November 12 2020, 11:01 PM , By : M_S
printing gridlines in excel through interop
printing gridlines in excel through interop
I hope this helps . I'm trying to export DataGridView items to Excel file and everything perfect, but I want the gridlines appear when the client want to print the sheet, I can do this from inside excel as shown here. , First change the following cod
TAG : excel
Date : November 11 2020, 11:01 PM , By : Chris
Evaluate and Store Complex Expression in Excel VBA
Evaluate and Store Complex Expression in Excel VBA
should help you out Here is a solution that I was able to figure out, though I am not sure if it is the most efficient. In line before the formula is set, I set a Range named BalanceCell to the cell where the formula will be written. I then used the
TAG : excel
Date : November 10 2020, 11:01 PM , By : fred martin
How to remember value of public variable and use it when open excel file in the next time use VBA in outlook
How to remember value of public variable and use it when open excel file in the next time use VBA in outlook
Hope that helps The following has code to store information in the Registry (SaveMySettings) and retrieve this information (RetrieveMySettings).The program saves two kevaluesys, "Item 1" and "Item 2" in this Registry key: HKEY_CURRENT_USER\Software\V
TAG : excel
Date : November 09 2020, 11:01 PM , By : luoshouhong
Pulling data from Excel file within Fortran
Pulling data from Excel file within Fortran
may help you . Your file is completely incompatible with how you are reading it.The command
TAG : excel
Date : November 09 2020, 11:01 PM , By : Frank
Conditional formatting a subset of cells based on a formula
Conditional formatting a subset of cells based on a formula
it helps some times I had thought that my question here: , Use this formula in conditional formatting
TAG : excel
Date : November 06 2020, 11:01 PM , By : Naveed Jan
In a subset of cells, determine if at least one corresponding cell matches a value
In a subset of cells, determine if at least one corresponding cell matches a value
it helps some times Given a table (spreadsheet) of two columns, for a subset of cells in column A that meet a particular criterion, determine if at least one of the corresponding cells in column B meet some other criterion.
TAG : excel
Date : November 05 2020, 11:01 PM , By : Tnorfotkcab
Golang excel file reading
Golang excel file reading
seems to work fine func OpenReaderAt(r io.ReaderAt, size int64) (*File, error)xlsx.OpenReaderAt takes in an io.ReaderAt interface and multipart.File also implements io.ReaderAt.
TAG : excel
Date : November 05 2020, 11:01 PM , By : Saira Hassan
Conditional formatting based on cell value
Conditional formatting based on cell value
I wish this helpful for you My Excel sheet looks like this:
TAG : excel
Date : November 04 2020, 11:01 PM , By : Pierre-Yves Dienst
Change hyperlink text in cell using string function(s)
Change hyperlink text in cell using string function(s)
Any of those help I'm not sure if this will keep your link, or break it. If it breaks it, let me know.
TAG : excel
Date : November 04 2020, 04:05 PM , By : vikranth
If active sheet code name equals then exit sub
If active sheet code name equals then exit sub
This might help you Is there a why this code be shortened down to 1 line, Code works but would like to consolidate it. , I dont really understand your question...You mean like use Or?
TAG : excel
Date : November 04 2020, 04:05 PM , By : evelyn.zhang
Open Excel 2016 file failed with HRESULT: 0x800706BE
Open Excel 2016 file failed with HRESULT: 0x800706BE
it fixes the issue The solution to resolve this exception upon calling the 'Open' method on the Excel application is to set Excel application to be visible:
TAG : excel
Date : November 04 2020, 04:05 PM , By : sharath R P
Google Sheets Query double group by for data
Google Sheets Query double group by for data
Does that help I found the answer - it was using pivot and group by at the same time:=query(AR6:AT15,"select AS, avg(AT) group by AS pivot AR")
TAG : excel
Date : November 04 2020, 04:05 PM , By : Virtualwebs servers
IF and AND to check one value in a range
IF and AND to check one value in a range
this will help I suggest you look at the vlookup function, it should do what you want.
TAG : excel
Date : November 03 2020, 11:01 PM , By : mukesh
How to read value in 2 dimensional array?
How to read value in 2 dimensional array?
Any of those help In VBA, i have a function to get data and save it in array: , Array index starts at 1 in this instance. Use:
TAG : excel
Date : November 03 2020, 11:01 PM , By : Mido
Using sheet codename in sorting code
Using sheet codename in sorting code
it should still fix some issue I've been trying to write all my code using codenames to prevent errors if a name gets changed and to stop activating/selecting sheets. This was going well until I got to the sort code where I thought the following woul
TAG : excel
Date : November 02 2020, 11:01 PM , By : Jhon Tony
Excel validate a specific string combination eg: g.2016.10.s
Excel validate a specific string combination eg: g.2016.10.s
may help you . select the cell A1 and then go to Data > Data Tools > Data Validation and then in Settings change Allow to Custom and write this formula:
TAG : excel
Date : November 01 2020, 11:01 PM , By : user6058733
VBA Interop: Is there a way to Explicitly use Excel data types in a word macro and vise versa?
VBA Interop: Is there a way to Explicitly use Excel data types in a word macro and vise versa?
seems to work fine In the VBA editor, in the Tools menu choose References then add "Microsoft Excel . Object Library" to your Word VBA project. This will give you access to all of Excel's objects. Note that some object names, e.g. "Range" represent d
TAG : excel
Date : November 01 2020, 11:01 PM , By : David
How to create a message box for more than 160 rows (10836), to display text in multiple columns depending on which row i
How to create a message box for more than 160 rows (10836), to display text in multiple columns depending on which row i
I wish did fix the issue. I was thinking along the same lines as Darren Bartrup-Cook; here it is in full:
TAG : excel
Date : November 01 2020, 11:01 PM , By : tester45045
how to copy cells from sheet 1 to sheet 2 without removing data on sheet 2
how to copy cells from sheet 1 to sheet 2 without removing data on sheet 2
I wish this helpful for you I need code, as my title suggests, for the following task. I already tried a lot of different code but it's still not working. I only need to move 2 columns, "SKU" and "Discount", into sheet2 using command button and delet
TAG : excel
Date : November 01 2020, 11:01 PM , By : Uchiram
Excel VBA - Error Adding Hyperlink to Another Workbook
Excel VBA - Error Adding Hyperlink to Another Workbook
may help you . Based on the code that I got when I recorded creating a hyperlink seems like you need to just remove everything before ws2.Hyperlinks.... The hyperlink creation code contains the cell to put the link in, so I think it inherently fills
TAG : excel
Date : November 01 2020, 01:04 PM , By : Jolien Willems
Finding at least one item in a VBA array in a range
Finding at least one item in a VBA array in a range
wish helps you I'm currently trying to find at least one item from my array in a range before proceeding, but the way I'm currently doing it checks that all values are in the range. , You could write a function like this:
TAG : excel
Date : November 01 2020, 01:04 PM , By : Cammatic
Excel conditional formatting - multiple "begins with" statements
Excel conditional formatting - multiple "begins with" statements
this one helps. This formula worked for me. It only formats the cell if it begins with the letters you specified. I wasn't sure if you wanted different formatting for each letter.
TAG : excel
Date : November 01 2020, 01:04 PM , By : Asakiewicz
Disable/Enable Tabstrip on Multitab based on Checkbox value- EXCEL
Disable/Enable Tabstrip on Multitab based on Checkbox value- EXCEL
I hope this helps . Me.MultiPageName.Pages(index).enabled = falseMe = the form active where multipage is present MulitipageName = named multipage Index = place of the page to enable copied from:http://www.excelforum.com/excel-programming-vba-macros/5
TAG : excel
Date : November 01 2020, 01:04 PM , By : Fipy
How to use wildcard in Cubevalue formula in Excel?
How to use wildcard in Cubevalue formula in Excel?
Hope that helps I am trying to get the values with wildcard in Cubevalue formula(below) in excel. I am not finding any solution. , First create a =CUBESET function in cell A1.
TAG : excel
Date : November 01 2020, 01:04 PM , By : J Patrick Lanigan
Excel - Finding adjacent cells that equal a certain value
Excel - Finding adjacent cells that equal a certain value
I wish this helpful for you I have an issue in Excel where I need to find if two adjacent cells are both equal to 100. I need some way to change a cells value to true or false based on this condition. Here is an example data set , You can use countif
TAG : excel
Date : November 01 2020, 12:01 AM , By : Max
Excel database from WEB in VBA
Excel database from WEB in VBA
I think the issue was by ths following , I would like to make a database of all companies from my city in Excel from this site: http://panoramafirm.pl/szukaj/małopolskie,olkuski,olkusz/firmy,1 , Page 95 doesn't have an element with the classname text
TAG : excel
Date : November 01 2020, 12:01 AM , By : Ulises
Insert url to new web query using cell url
Insert url to new web query using cell url
this one helps. I have a cell with a url. I want to make a macro that records from selecting data from a website using the url in cell e.g. B2 to reach the website. I have searched the internet and can't find the answer anywhere. Can anyone help? , T
TAG : excel
Date : November 01 2020, 12:01 AM , By : Nadiir
Leave cell formatting intact
Leave cell formatting intact
this one helps. I tested this and it seemed to work on my test data, for some reason excel is treating "---" as a value larger than 0.8 so moving the check for "---" first will stop this.
TAG : excel
Date : October 31 2020, 05:38 PM , By : Maddog
Return to sheet where button was pushed
Return to sheet where button was pushed
like below fixes the issue I have the following macro that selects cell A3 in every sheet: , Check this
TAG : excel
Date : October 31 2020, 09:54 AM , By : Richard Wood
VBA Script fails when trying to save as .XLSX
VBA Script fails when trying to save as .XLSX
Hope that helps Because SaveAs is a Method of the Workbook object, it can't be assigned a value, so you can't have a statement of the form:
TAG : excel
Date : October 31 2020, 12:01 AM , By : bangthatdrum
Excel - hide subs from being displayed in the 'Customize Ribbon' dialog
Excel - hide subs from being displayed in the 'Customize Ribbon' dialog
I wish did fix the issue. If you write Option Private Module on top and you make the subroutines private, they would not be visible.See more here for Option Private Module.
TAG : excel
Date : October 31 2020, 12:01 AM , By : Ionut Merean
excel formula with sum offset and match doesn't work
excel formula with sum offset and match doesn't work
Hope this helps The -1 you've got in the match formula is setting the lookup type to be less than or equal. The -1 wants to be outside the match function, to make sure that the range doesn't include the cell it's being called from, which is what is c
TAG : excel
Date : October 30 2020, 12:01 AM , By : Vincent Dosumu
To many if statements to handle
To many if statements to handle
I think the issue was by ths following , I have a sheet I want to maintain regarding progress in a evaluation project. , you can nest them :) it seems easier to read if you flip the >
TAG : excel
Date : October 30 2020, 12:01 AM , By : Jakir Hossain Kalapu
how do i get count of specific column used range
how do i get count of specific column used range
seems to work fine You can use this to find the last visible cell containing data in column F. Note that this is not neccessarily what Excel thinks is the last used cell in column F
TAG : excel
Date : October 29 2020, 12:01 AM , By : gautam saini
INDEX MATCH result is always the same
INDEX MATCH result is always the same
will be helpful for those in need I have created a macro to index match some values between two sheets.. However, even if the index match works, it only prints the same result.. I am providing this part of the code with the index match order. , You d
TAG : excel
Date : October 26 2020, 11:56 AM , By : Pratap Patna
Data Extraction over multiple worksheets
Data Extraction over multiple worksheets
seems to work fine Try this. I've added a worksheet variable ws. This puts the sheet name in column A of the new workbook, and the data in col B onwards. I have also added declarations for all the variables.
TAG : excel
Date : October 25 2020, 02:08 AM , By : Kamal Ranga
Running multiple subs one at a time
Running multiple subs one at a time
To fix the issue you can do I have created a workbook, which I will use to call my other workbooks and their macros from. I have a assigned the sub "knap" to a button, which I will press whenever I need to update. However when I press the button and
TAG : excel
Date : October 24 2020, 03:08 PM , By : Yuvrajsinh Parmar
Copy a variably named worksheet from one workbook to another
Copy a variably named worksheet from one workbook to another
will help you I would use the Worksheet.copy method to copy the Worksheet to the new Workbook, this should preserve the formatting of the original sheet. Here's the code updated with comments:
TAG : excel
Date : October 24 2020, 03:08 PM , By : jg kim
Editing date to DD-mmm-YYYY format
Editing date to DD-mmm-YYYY format
I wish this helpful for you I am looking to format a date in Excel properly using VBA. I have looked at other solutions and it hasn't helped. , do not use .Select it slows down the code.
TAG : excel
Date : October 24 2020, 01:08 AM , By : Adam Kardas

shadow
Privacy Policy - Terms - Contact Us © soohba.com