Microsoft Excel

129K

Solutions

187

Articles & Videos

33K

Contributors

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Related Topics

  1. Microsoft Office
  2. Visual Basic Classic
  3. VB Script
  4. Microsoft Applications
  5. Spreadsheets
  6. Microsoft Access
  7. VBA
  8. Microsoft Word
  9. Programming
  10. Visual Basic.NET
Refine results

Dear Experts,

i'm trying to accomplish the following. I need to generate 350+ confidential documents which will be distributed.
On these Documents there should be a personal Watermark with the …

529 views
Free Tool: Port Scanner
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Hi

What VB.net code would I use to make a TaskPane float?

Thanks

25 views

Dear sir, i have set of values in column A,B and so on each column has header name and their values are below the header name row for (e.g) 1 to 10 rows have values 1 to 10. and below that row another…

223 views

Experts,

 We have sharepoint 2013 and we created the dashboard in excel and displaying with excel web services. We want this web page look like dashboard. We want to hide or get rid off scroll bar …

414 views

SO THE FORMULA CAN RUN !!

212 views

I have  data i need to ajust

for example
if the number is  534  I need to convert in 435

have to be even  first in this order
2 4 6 8 0 and odd in this order 1 3 5 7 9
lets say

288 =288…

816 views

as i need see the results
as i type in but sometimes work and  others No ! why !!

here an example

414 views

hi
I'm attaching a file that shows the following - date, start time, finish time. If the start and finish times are within the same day, it's fine - but how do I show the time waiting if it spans a …

827 views

like this ! sample !!

914 views

I have this VLOOKUP formula in my Excel:

=IFERROR(VLOOKUP($K$5;Travbanor!$B$6:$M$100;12;FALSE);"")

And it finds the value 1.7 in column 12 from the left without problems.

Then I change to …

413 views
Free Tool: Site Down Detector
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Hello EE,

Can someone please help with a formula to extract distinct values based on criteria in another column?  I want to extract unique values where the data in the name column is not blank.  …

158 views

This is my current formula (the calculation works fine):

=IFERROR(IF(AND(OR($M$4="volt";$M$4="auto");Q33<>0);Q33-$F$26;Q33+$F$26);"")

But I want that if Q33 has no value (but there is a formula…

616 views

Hello,

I'm sorry for asking the solution again as the last one did not work as required, but I thank Shams for helping me understand the way it is done. :)

But the problem stays as it is.

So…

414 views

I had this question after viewing Export CSV from Excel and exclude rows based on cell value …

425 views

I am looking for a formula to put the "status" of a project from the worksheet Matrix (2) in the right row of the reference table (1). I tried index match but could not solve the problem.

In the ws…

619 views

I have this formula in Q13:

=IF(OR($Q19="2: 1/4";"2: halv");0.225*1*0.25;0.225*1*0.5)

Then in Q19 I have a drop-down list with these values:

   -  
2: 1/4
2: halv

Note that the first …

1517 views

I have a worksheet with multiple sheets within. In column A (RUP) of sheet 1 I have check boxes (which aren't working). I need all of the data in each row from the main sheet to copy to the RUP sheet …

322 views

I have a daily routine that involves downloading a list that I need the cell contents of several columns to be populated into a comment for the cell in column A for the same row -- but also have the …

812 views

Hello,
I'm new in excel and vlookup, so consider me a near zero knowledge in vlookup and conditional formatting.

query:

Advisor:      Total  CSAT%
 Abhishek Deb                    77.92%
 AJAY KUMAR …

520 views
Free Tool: IP Lookup
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Hello everyone.
Please I really need help.
I have a matrix that I want to square (multiplying it by itself).
and then I'm gonna add the value of each row of this matrix, and then add the value of …

1641 views

HAVE A COLUMN WITH DATA  NEED TO BE REORGANIZED

THIS WAY

5921 views

I'm trying to sum the number of dates with in a range for a given document type using SUMPRODUCT in the attached example spreadsheet.

I can get the formula to return the correct value for a single …

618 views

i need a formula to count the number of capital letters in an excel formula

314 views

Hi Experts,

I have a somewhat complicated issue that I think might be resolved with the use of a combination of an Index Match Array formula but can't see how to do it.  That said, there may be …

537 views

I need a vba loop to remove all instances of these shapes.
There are multiple, and for some reason and this code only removes one, not all.
I need to loop through until there are no more.


411 views
Show more content
201506-LO-Top-001

Microsoft Excel

129K

Solutions

187

Articles & Videos

33K

Contributors

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Related Topics

  1. Microsoft Office
  2. Visual Basic Classic
  3. VB Script
  4. Microsoft Applications
  5. Spreadsheets
  6. Microsoft Access