Trending questions in Others

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,295 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,523 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,026 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,090 views
0 votes
1 answer

Is there a maximum number of formula fields allowed in Excel (2010)

See http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010073849.aspx for limits on specs it doesn't indicate ...READ MORE

Sep 30, 2022 in Others by narikkadan
 • 63,600 points • 1,088 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 • 621 views
0 votes
1 answer

aws s3 replace file atomically

Simply upload your new file on top ...READ MORE

Mar 24, 2022 in Others by gaurav
 • 23,260 points • 9,303 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,203 views
0 votes
1 answer

Convert CASE WHEN logic from SQL to EXCEL

A combination of IF(), ISNUMBER(SEARCH()), and OR() ...READ MORE

Sep 21, 2022 in Others by narikkadan
 • 63,600 points • 1,448 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,025 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 • 438 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 • 880 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,236 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 • 563 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,273 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,056 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,355 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 • 893 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 • 644 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,306 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 • 905 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,199 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,041 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 • 509 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 • 463 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,629 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 • 865 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,017 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 • 624 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,308 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 • 570 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 • 841 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,290 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 • 767 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 • 644 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,215 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 • 927 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,026 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,197 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 • 979 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 • 697 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,158 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 • 868 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 • 744 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 • 913 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 • 636 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 • 930 views
0 votes
1 answer

I want to include a pdf to excel converter in my template?

You're app hosted locally only?  But even ...READ MORE

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

VBA automatically agree to enable macros

Typically, there is no security alert when ...READ MORE

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

Removing duplicates from Excel rows by adding values of some columns

Copy the first three columns to another ...READ MORE

Sep 23, 2022 in Others by narikkadan
 • 63,600 points • 1,009 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.