Trending questions in Others

0 votes
1 answer

Convert image (jpg, png, jpeg) to base64

Try this - it will perform the ...READ MORE

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

VBA Code to Populate Balance Sheet from Trial Balance Data

It appears that what you need to ...READ MORE

Sep 24, 2022 in Others by narikkadan
 • 63,600 points • 1,231 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 • 781 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 • 879 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 • 464 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,115 views
0 votes
1 answer

Extract unique value from the range in Excel

The portability of spreadsheet functions like UNIQUE() ...READ MORE

Sep 23, 2022 in Others by narikkadan
 • 63,600 points • 1,233 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 • 883 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 • 820 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 • 768 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,069 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 • 401 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 • 533 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,011 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 • 421 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,170 views
0 votes
1 answer

Provide an image for WhatsApp link sharing

the problem is with the size of ...READ MORE

Feb 28, 2022 in Others by narikkadan
 • 63,600 points • 10,108 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 • 862 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,077 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 • 498 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 • 526 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 • 839 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 • 901 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,128 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 • 880 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 • 684 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 • 701 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 • 852 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 • 999 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,145 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,114 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 • 636 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 • 8,987 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,412 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 • 494 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 • 642 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,071 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,062 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 • 782 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 • 556 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 • 815 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 • 850 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,053 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 • 587 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,036 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 • 605 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 • 794 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 • 896 views
0 votes
1 answer

Excel - IF Formula with a FIND

What about using mid() to see if ...READ MORE

Sep 27, 2022 in Others by narikkadan
 • 63,600 points • 717 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 • 757 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.