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 …
Hi
What VB.net code would I use to make a TaskPane float?
Thanks
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…
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 …
SO THE FORMULA CAN RUN !!
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…
as i need see the results
as i type in but sometimes work and others No ! why !!
here an example
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 …
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 …
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. …
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…
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…
I had this question after viewing Export CSV from Excel and exclude rows based on cell value …
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…
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 dropdown list with these values:

2: 1/4
2: halv
Note that the first …
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 …
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 …
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 …
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 …
HAVE A COLUMN WITH DATA NEED TO BE REORGANIZED
THIS WAY
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 …
i need a formula to count the number of capital letters in an excel formula
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 …
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.
…