Trending questions in Others

0 votes
1 answer

Excel, How to split cells by comma delimiter into new cells

The Excel manual method: choose Text to Column ...READ MORE

Oct 3, 2022 in Others by narikkadan
 • 63,600 points • 1,062 views
0 votes
1 answer

Excel OFFSET function with a dynamic row argument

The answer is to make "anchor cells" ...READ MORE

Sep 26, 2022 in Others by narikkadan
 • 63,600 points • 1,364 views
0 votes
1 answer

Embedding an excel document into an application with excel online

You have to do the heavy lifting ...READ MORE

Oct 2, 2022 in Others by narikkadan
 • 63,600 points • 1,089 views
0 votes
1 answer

Navigate Excel Drop-Down List via Keyboard

You are aware of the auto-complete feature ...READ MORE

Oct 10, 2022 in Others by narikkadan
 • 63,600 points • 715 views
0 votes
1 answer

Opening Selected Hyperlink DISPLAYING TEXT in Default Browser in MS Excel

Try this code: Sub Open_SelectedTextlinks() If Not ...READ MORE

Oct 7, 2022 in Others by narikkadan
 • 63,600 points • 840 views
0 votes
1 answer

iPhone system font

The iPhone system interface uses Helvetica or ...READ MORE

Sep 20, 2022 in Others by Aditya
 • 7,680 points • 1,567 views
0 votes
1 answer

Export csv separated by columns

Define FileFormat as xlText and the file will be TAB delimited, ...READ MORE

Oct 15, 2022 in Others by narikkadan
 • 63,600 points • 480 views
0 votes
1 answer

Unhide rows in Excel with VBA

Paste this code into a module of ...READ MORE

Oct 1, 2022 in Others by narikkadan
 • 63,600 points • 1,102 views
0 votes
1 answer

Equivalent of Excel Round function

Here's a sample LINQPad program that demonstrates one way ...READ MORE

Sep 26, 2022 in Others by narikkadan
 • 63,600 points • 1,318 views
0 votes
1 answer

How to compress Excel buffer into ZIP buffer?

The problem is that something you're using ...READ MORE

Sep 23, 2022 in Others by narikkadan
 • 63,600 points • 1,439 views
0 votes
1 answer

How to create a drop-down in excel with custom values

You can accomplish that using code rather ...READ MORE

Sep 25, 2022 in Others by narikkadan
 • 63,600 points • 1,351 views
0 votes
1 answer

Goal Seek in Excel

The pmt function we are using, which ...READ MORE

Sep 30, 2022 in Others by narikkadan
 • 63,600 points • 1,133 views
0 votes
1 answer

IF formula to compare a date with current date and return result

You can enter the following formula in ...READ MORE

Sep 27, 2022 in Others by narikkadan
 • 63,600 points • 1,262 views
0 votes
1 answer

Using Excel VLOOKUP() function across two sheets

The syntax for VLOOKUP is VLOOKUP(Lookup_Value,Table Array,Col_index_num,Range_lookup) OR, to start in ...READ MORE

Sep 30, 2022 in Others by narikkadan
 • 63,600 points • 1,132 views
0 votes
1 answer

How to get rid of a #value error in Excel?

Changing the format to "Number" doesn't actually ...READ MORE

Oct 3, 2022 in Others by narikkadan
 • 63,600 points • 935 views
0 votes
1 answer

Absolute worksheet reference in excel cell formulas

Try this: =INDIRECT("Sheet1!C"&ROW()) READ MORE

Oct 10, 2022 in Others by narikkadan
 • 63,600 points • 655 views
0 votes
1 answer

Creating a chart in VBA with 2 different Types

Can you carry this out by hand ...READ MORE

Oct 11, 2022 in Others by narikkadan
 • 63,600 points • 603 views
0 votes
1 answer

Chart Name in Excel 2016

When you select the chart, it's now ...READ MORE

Oct 14, 2022 in Others by narikkadan
 • 63,600 points • 464 views
0 votes
1 answer

How to use the INDIRECT function in Excel

Try this: =INDEX(INDIRECT($A$1&"!$1:$1048576"),MATCH($B$1,INDI ...READ MORE

Sep 29, 2022 in Others by narikkadan
 • 63,600 points • 1,132 views
0 votes
1 answer

Git error: "Please make sure you have the correct access rights and the repository exists"

Your git URL might have changed. Change ...READ MORE

Feb 17, 2022 in Others by Aditya
 • 7,680 points • 10,738 views
0 votes
1 answer

Calculate age in excel

Write =Today-C3 and then press Ctrl+1 and select Number for the format.  Or try ...READ MORE

Oct 3, 2022 in Others by narikkadan
 • 63,600 points • 933 views
0 votes
1 answer

Excel automatically converting 7 digit CAS number to another number (date?)

Looks like you could use: The formula in D2: =SUBSTITUTE(F ...READ MORE

Sep 25, 2022 in Others by narikkadan
 • 63,600 points • 1,279 views
0 votes
1 answer

How to link two min max sliders with swiftui iOS15

I see you asked it a long ...READ MORE

Sep 22, 2022 in Others by rajatha
 • 7,680 points • 1,362 views
0 votes
1 answer

Split text cells in 70 character chunks in Excel

You can do this using Power Query Data ...READ MORE

Oct 2, 2022 in Others by narikkadan
 • 63,600 points • 961 views
0 votes
1 answer

Change the size of one cell in excel 2016

I'm sorry, but it's not feasible. A ...READ MORE

Oct 8, 2022 in Others by narikkadan
 • 63,600 points • 684 views
0 votes
1 answer

Excel VBA if file closed, then open and paste, else just paste data

Slightly re-worked to add full workbook/sheet qualifiers ...READ MORE

Sep 21, 2022 in Others by narikkadan
 • 63,600 points • 1,412 views
0 votes
1 answer

How to Paste JPEG as a gif in excel?

Solution  Step 1 Navigate to the folder that contains ...READ MORE

Oct 2, 2022 in Others by narikkadan
 • 63,600 points • 945 views
0 votes
1 answer

Excel vba domdocument parsing xml from TNT tracking system: in some pcs object load return no document

This error is related to something in ...READ MORE

Sep 21, 2022 in Others by narikkadan
 • 63,600 points • 1,377 views
0 votes
1 answer

How to trigger Excel AutoFill using power Automate?

In PAD you may want copy the ...READ MORE

Sep 29, 2022 in Others by narikkadan
 • 63,600 points • 1,063 views
0 votes
1 answer

Batch generate merged .jpg from excel data sheet

Refer to this blog and follow the ...READ MORE

Oct 10, 2022 in Others by narikkadan
 • 63,600 points • 540 views
0 votes
1 answer

MS Excel - Concat with a delimiter

Use TEXTJOIN() instead: =TEXTJOIN(";",TRUE,A1:A2000) I hope this ...READ MORE

Oct 2, 2022 in Others by narikkadan
 • 63,600 points • 906 views
0 votes
1 answer

Creating macro in excel

The Macro Recorder is used to record ...READ MORE

Oct 11, 2022 in Others by narikkadan
 • 63,600 points • 492 views
0 votes
1 answer

Excel 2013 - using Boolean logical functions

If p is stored in A1 and ...READ MORE

Oct 7, 2022 in Others by narikkadan
 • 63,600 points • 657 views
0 votes
1 answer

Can I use VBA in Excel 2010 Starter Edition?

No, unfortunately you can't use VBA in ...READ MORE

Oct 8, 2022 in Others by narikkadan
 • 63,600 points • 602 views
0 votes
1 answer

what is microsoft azure used for?

Microsoft Azure is used as a cloud ...READ MORE

Jun 21, 2023 in Others by Khan Sarfaraz
• 700 points • 709 views
0 votes
1 answer

Convert PDF into excel data

To convert data from an image in ...READ MORE

Oct 3, 2022 in Others by narikkadan
 • 63,600 points • 809 views
0 votes
1 answer

Trouble with excel macros (possibly encoding?)

To solve your issue: Replace your macro names ...READ MORE

Sep 26, 2022 in Others by narikkadan
 • 63,600 points • 1,099 views
0 votes
1 answer

Rounded corners on iOS 13 page sheet

In your view controller, you can change ...READ MORE

Sep 21, 2022 in Others by rajatha
 • 7,680 points • 1,257 views
0 votes
0 answers

Creating an Instagram bot with reading an excel file and posing on Instagram, but some of words can not be read properly

from instabot import Bot import openpyxl import smtplib bot = ...READ MORE

Sep 26, 2022 in Others by Kithuzzz
 • 38,000 points • 1,057 views
0 votes
1 answer

ios: localize emoji name (kCFStringTransformToUnicodeName)

There is no api for this job. Unicode ...READ MORE

Sep 21, 2022 in Others by rajatha
 • 7,680 points • 1,240 views
0 votes
1 answer

An error for excel download in Firefox for JMeter script recording

You shouldn't just copy and paste configuration ...READ MORE

Sep 29, 2022 in Others by narikkadan
 • 63,600 points • 953 views
0 votes
1 answer

On focus after tabbing of Excel drop down, automatically show list for selection

Put the following code in the Microsoft ...READ MORE

Oct 3, 2022 in Others by narikkadan
 • 63,600 points • 743 views
0 votes
1 answer

Excel - add all X in column and then multiply

Use countif for the count then multiply ...READ MORE

Oct 1, 2022 in Others by narikkadan
 • 63,600 points • 807 views
0 votes
1 answer

How to select random value from iOS picker wheel using Selenium

Two ways to do this : Randomise the UIAPickerWheel[1] index ...READ MORE

Sep 21, 2022 in Others by rajatha
 • 7,680 points • 1,193 views
0 votes
1 answer

Excel COUNTIF formula

Please see MS Excel: COUNTIF Function (WS) You should ...READ MORE

Sep 29, 2022 in Others by narikkadan
 • 63,600 points • 905 views
0 votes
1 answer

Excel If field with rounding

Here's your formula. Assumes your cell containing ...READ MORE

Sep 27, 2022 in Others by narikkadan
 • 63,600 points • 960 views
0 votes
0 answers

What is the relationship between iostream and namespace std?

I am currently using Teach Yourself C++ in ...READ MORE

Sep 22, 2022 in Others by gaurav
 • 23,260 points • 1,129 views
0 votes
1 answer

JavaScript API does not work for Excel 2013?

Each method in the Office.js APIs is ...READ MORE

Sep 26, 2022 in Others by narikkadan
 • 63,600 points • 997 views
0 votes
1 answer

Get last modified object from S3 using AWS CLI

Try this command $ aws s3api list-objects --bucket ...READ MORE

Sep 20, 2022 in Others by anonymous
edited Mar 5 • 5,110 views
0 votes
1 answer

Using an excel invoice template to consecutively add items to sales data book, keeping individual customers on their own specific row

You will need to modify those to ...READ MORE

Oct 3, 2022 in Others by narikkadan
 • 63,600 points • 672 views
Page:

Most popular tags

"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.