#excel #file error

( i was try to making Auto filter data) "When I paste data into a table, the data should be sorted by invoice number, pleased Share to right way vba to possible Tricks"

(1) How to get reference Sheet 1 to Sheet 2 (2) We Need four Option Reference According Match Question on Sheet 1 *Kindly make this formula for "sheet2" Condition 1 :- i will change Serial Number After Change Question in "sheet 2" (match Serial no. and question to "sheet1") Condition...

Guys, I am a newbie to Excel and I'd like to know how I can make an IF function work with a number range in between a range of numbers. Let's say I want to say that IF B8 is equal to 9 up to 10, it is good. How can I do that? because it is impossible for me. to run it as =IF (B8=9-10, “Good")

This Formula use , Missing Date find perfect , but we need Find "Bill Number " , Because my file Large Amount of Bill Numbers ( May be 3000 Bill Number ) =SMALL(IF(ISERROR(MATCH($E$2+ROW(OFFSET($B$2,0,0,$E$3-$E$2+1))-2,$B$3:$B$7,0)),$E$2+ROW(OFFSET($B$2,0,0,$E$3-$E$2+1))-2),ROW(A1)) ( This...

@ HOW TO LOCK COLUMNS ??? I try Column " A" & "B" FIX & Lock ....... This "HSN CODE " IS EVERY TIME FIX & SAME IN BILL ......... Problem : 5 and more people use this File, So my was Change every time , i tried ... We Need lock Columns lock trick .. pleased solve my Query.

(NEED THIS CONDITION) C2= "20 ft" use 5,00,000 C2= "40 ft" use 10,00,000 Change value According "20 ft" Or "40 ft " ------------------------------Kindly Suggest Right Formula-----------------

PC A & B : win7 , x64 , 4GB RAM , microsoft office 2010 PC C : win7 , x64 , 4GB RAM , microsoft office 2007 sample.xls is sharing from server for everyone. PC A & C can view sample.xls completely without any error. PC B open sample.xls and popup "File error:data may have...