Most viewed questions in Others

0 votes
1 answer

Excel If Functions with Multiple Conditions

Use this: =IF(C3<=0,"Green",IF(C3<500,"Silver",IF(C3<=1499,"Gold","Platinum"))) I added <=0 just in case you have ...READ MORE

Dec 13, 2022 in Others by narikkadan
 • 63,700 points • 285 views
0 votes
0 answers

What is the best way to use a HashMap in C++?

Can someone recommend me some good documentation ...READ MORE

May 19, 2022 in Others by Kichu
 • 19,050 points • 285 views
0 votes
0 answers

AWS S3 Cross Region Replication - When there is outage

I have a primary bucket that stores ...READ MORE

Apr 23, 2022 in Others by Kichu
 • 19,050 points • 285 views
0 votes
1 answer

Need a formula that will pull the specific value that matches a unique code from a set of data and produce another table of that specific data

VLOOKUP will work: vlookup =VLOOKUP(G2,$A$2:$D$11,3,FALS ...READ MORE

Jan 23, 2023 in Others by narikkadan
 • 63,700 points • 284 views
0 votes
1 answer

Horizontal Loop

There is no need to use Range if you ...READ MORE

Jan 15, 2023 in Others by narikkadan
 • 63,700 points • 284 views
0 votes
1 answer

"Advance" an Excel formula via keyboard shortcut while in edit mode?

As requested, you can carry out the ...READ MORE

Dec 10, 2022 in Others by narikkadan
 • 63,700 points • 284 views
0 votes
0 answers

How to convert a string to an integer in JavaScript?

How do I convert a string to ...READ MORE

May 2, 2022 in Others by Kichu
 • 19,050 points • 284 views
0 votes
1 answer

Runtime Error while dynamically adding controls to a userform

You appear to be attempting to execute ...READ MORE

Mar 27, 2023 in Others by narikkadan
 • 63,700 points • 283 views
0 votes
0 answers

Input Box Date Validation

I have an update form for my ...READ MORE

Feb 27, 2023 in Others by Kithuzzz
 • 38,010 points • 283 views
0 votes
1 answer

Showing percentages above bars on Excel column graph

Solution  Use a line series to show the ...READ MORE

Nov 17, 2022 in Others by narikkadan
 • 63,700 points • 283 views
0 votes
1 answer

Excel Formula Meaning of $

It's an absolute reference: it means don't treat ...READ MORE

Nov 5, 2022 in Others by narikkadan
 • 63,700 points • 283 views
0 votes
0 answers

How do I get data storage used on my AWS RDS?

I wish to know how much storage ...READ MORE

Apr 9, 2022 in Others by Kichu
 • 19,050 points • 283 views
0 votes
1 answer

Python: How do I get multiple results in the same excel sheet?

Try this: fmin = lambda x: abs(x).min() fmax = ...READ MORE

Mar 25, 2023 in Others by narikkadan
 • 63,700 points • 282 views
0 votes
1 answer

Encrypting and securing sheets for users

First off, instead of using a formula ...READ MORE

Mar 21, 2023 in Others by Kithuzzz
 • 38,010 points • 282 views
0 votes
1 answer

Trying to apply Solver with Macros

The  MaxMinVal was when you wanted to ...READ MORE

Jan 10, 2023 in Others by narikkadan
 • 63,700 points • 282 views
0 votes
1 answer

Image once saved to sdcard doesn't appear in Android's Gallery app

The system scans the SD card when ...READ MORE

May 31, 2022 in Others by nisha
 • 2,210 points • 282 views
0 votes
1 answer

VBA - user input of row value to use in a cell range

Use this: Range("C" & c & ":I" & ...READ MORE

Feb 7, 2023 in Others by narikkadan
 • 63,700 points • 281 views
0 votes
1 answer

Frequency Array formula EXCEL not calculating

You obtain the same outcome, which suggests ...READ MORE

Oct 31, 2022 in Others by narikkadan
 • 63,700 points • 281 views
0 votes
1 answer

Comparing data in Excel

A quick and mildly dirty VBA approach. ...READ MORE

Jan 20, 2023 in Others by narikkadan
 • 63,700 points • 280 views
0 votes
1 answer

Cell character counting formula?

With data in column A, in B1 enter: =SUMPRODUCT(--(LEN(A:A)=ROW())) Then copy downwards: I ...READ MORE

Nov 21, 2022 in Others by narikkadan
 • 63,700 points • 279 views
0 votes
1 answer

Difference between margin and padding?

In simple words, padding as a term ...READ MORE

Feb 18, 2022 in Others by Aditya
 • 7,680 points • 279 views
0 votes
1 answer

VBA Excel Adding pictures to a worksheet

It should work as: ActiveSheet.Pictures.Insert("C:\Work\test_Project\myjpgfile.jpg").Select As that's all the ...READ MORE

Jan 3, 2023 in Others by narikkadan
 • 63,700 points • 278 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,700 points • 278 views
0 votes
1 answer

seo component gatsby- effecting layout

<link ...READ MORE

Feb 20, 2022 in Others by narikkadan
 • 63,700 points • 278 views
0 votes
1 answer

Facebook Graph API split test for audience

for split testing Facebook /meta developers has ...READ MORE

Feb 18, 2022 in Others by narikkadan
 • 63,700 points • 278 views
0 votes
1 answer

How do I make my subs() not change inputdata in Vba excel

Use the ByVal keyword to pass on ...READ MORE

Feb 5, 2023 in Others by narikkadan
 • 63,700 points • 277 views
0 votes
1 answer

Excel formula to replace or stubstitute only text that starts with a certain letter

You're requesting a "formula." Normally, you would ...READ MORE

Nov 21, 2022 in Others by narikkadan
 • 63,700 points • 277 views
0 votes
1 answer

SEO META Tags HTML

search engines dont provide support for the ...READ MORE

Feb 22, 2022 in Others by narikkadan
 • 63,700 points • 277 views
0 votes
1 answer

How to split only one column to multiple rows while copying rest of the columns along the way?

Try this: =DROP(REDUCE(0,REDUCE(0,C2:C3,LAMBDA(a,x,VSTACK(a,CONCAT ...READ MORE

Feb 6, 2023 in Others by narikkadan
 • 63,700 points • 276 views
0 votes
1 answer

How to make a auto counter to print pages

This will loop through all of those ...READ MORE

Jan 19, 2023 in Others by narikkadan
 • 63,700 points • 276 views
0 votes
1 answer

Broken external links in Excel : a leading "file:///" scheme appended to paths can't be evaluated in formulas

If not already done, save and close ...READ MORE

Jan 7, 2023 in Others by narikkadan
 • 63,700 points • 276 views
0 votes
1 answer

How to fix corrupted imported online excel in google sheet?

Issue and workaround: In the built-in functions for ...READ MORE

Nov 26, 2022 in Others by narikkadan
 • 63,700 points • 276 views
0 votes
0 answers

Programming slim C++ programs (like uTorrent) for Windows

What methods do you recommend for writing ...READ MORE

May 13, 2022 in Others by Kichu
 • 19,050 points • 276 views
0 votes
0 answers

What causes a SIGSEGV?

What actually is the root cause of ...READ MORE

May 11, 2022 in Others by Kichu
 • 19,050 points • 276 views
0 votes
1 answer

VBA Switch from an open excel app to a different open Excel app

Switch Between Excel Instances Using AppActivate After app-activating, you ...READ MORE

Mar 30, 2023 in Others by narikkadan
 • 63,700 points • 275 views
0 votes
1 answer

Is there a hierarchy inferring algorithm available in python?

Convert the list of values to the ...READ MORE

Jan 15, 2023 in Others by narikkadan
 • 63,700 points • 275 views
0 votes
1 answer

Find function to locate result of a formula, in a cell

There are several attributes to the Find ...READ MORE

Nov 17, 2022 in Others by narikkadan
 • 63,700 points • 275 views
0 votes
0 answers

what is artificial intelligence

Dec 20, 2021 in Others by Edureka
 • 13,620 points • 275 views
0 votes
1 answer

Copy last 3 rows, excluding the rows for which there is a "0" in column "C"

The copy inside the loop is overwriting ...READ MORE

Jan 10, 2023 in Others by narikkadan
 • 63,700 points • 274 views
0 votes
1 answer

Excel - count days between two dates per year

Put this in C2 and copy over: =MIN(DATE(C1,12,31),$B$2)-MAX(DATE(C ...READ MORE

Dec 29, 2022 in Others by narikkadan
 • 63,700 points • 274 views
0 votes
1 answer

Facebook's BigPipe and SEO : Cloaking?

Facebook discriminate search bots and serve them ...READ MORE

Feb 28, 2022 in Others by narikkadan
 • 63,700 points • 274 views
0 votes
1 answer

Excel - VLOOKUP vs. INDEX/MATCH - Which is better?

Since it is much more adaptable and ...READ MORE

Dec 23, 2022 in Others by narikkadan
 • 63,700 points • 273 views
0 votes
1 answer

Does Java have a IN operator or function like SQL

A Java-language was designed to be powerful ...READ MORE

May 30, 2022 in Others by Sohail
 • 3,040 points
edited Jun 22, 2023 by Khan Sarfaraz • 273 views
0 votes
0 answers

S3 bucket policy: allow full access to a bucket and all its objects

I wanted a bucket policy that allows ...READ MORE

Apr 23, 2022 in Others by Kichu
 • 19,050 points • 273 views
0 votes
1 answer

Vba range object single column autofill

Just refer to the first column of rng. ...READ MORE

Apr 2, 2023 in Others by Kithuzzz
 • 38,010 points • 272 views
0 votes
1 answer

See cell content instead of formula in formulabox in Excel using VBA

A VBA Lookup: Lookup Headers in an ...READ MORE

Mar 27, 2023 in Others by narikkadan
 • 63,700 points • 272 views
0 votes
1 answer

How to split column into two

Using WRAPSROWS() • Formula used in cell C2 --> Exclusively Applicable To ...READ MORE

Feb 21, 2023 in Others by narikkadan
 • 63,700 points • 272 views
0 votes
1 answer

Excel If duplicate agree paste the value

With Office 365: =LET( nm,A2:A5, ...READ MORE

Jan 19, 2023 in Others by narikkadan
 • 63,700 points • 272 views
0 votes
1 answer

Excel remaining days count from today until due date minus weekends?

The problem is that you are not ...READ MORE

Nov 14, 2022 in Others by narikkadan
 • 63,700 points • 272 views
0 votes
0 answers

MS Excel - SumProduct formula with Loop

1 I have 4 arrays of data where ...READ MORE

Feb 18, 2022 in Others by Edureka
 • 13,670 points • 272 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.